Bumblebee Docs
  • Hi Bumblebee!
  • Install Bumblebee
    • Install via Docker
    • Build and Install From Source
  • Quick start
    • Setting up your first workspace
  • Bumblebee interface
    • Loading a Dataset
    • Saving a Dataset
    • Profile
    • Table
    • Columns
  • Transformations
    • Join dataframes
    • Rows functions
      • Sort rows
      • Filter rows
      • Drop empty rows
      • Drop duplicates
    • Column managing functions
      • Set
      • Rename
      • Duplicate
      • Keep
      • Drop
      • Nest
      • Unnest
    • Transformation functions
      • Fill null values
      • Replace
      • String functions
        • Lower case
        • Upper case
        • Proper case
        • Remove accents
        • Remove special chars
        • Normalize white spaces
        • Left (substring)
        • Right (substring)
        • Mid (substring)
      • Math functions
        • Absolute value
        • Round
        • Floor
        • Ceil
        • Modulo
        • Logarithm
        • Natural logarithm
        • Power
        • Square root
      • Trigonometric functions
        • Sine
        • Cosine
        • Tangent
        • Inverse Sine
        • Inverse Cosine
        • Inverse Tangent
        • Hyperbolic Sine
        • Hyperbolic Cosine
        • Hyperbolic Tangent
        • Inverse Hyperbolic Sine
        • Inverse Hyperbolic Cosine
        • Inverse Hyperbolic Tangent
      • Time and Date
        • Transform format
        • Year
        • Year (short)
        • Month name
        • Month name (short)
        • Month as a number
        • Day of month
        • Weekday
        • Weekday (short)
        • Weekday as a number
        • Minute
        • Hour (00-23)
        • AM/PM
        • UTC offset
        • Timezone
        • Day number of year
        • Weekday of year (Mon as 1st)
        • Weekday of year (Sun as 1st)
      • Web related functions
        • Domain
        • Subdomain
        • Url scheme
        • Port
        • Url path
        • Url params
        • Email domain
        • Email username
        • Strip HTML
      • Machine Learning
        • Random sampling
  • Help
    • Bigger than memory data
    • Which engine to use
Powered by GitBook
On this page
  • Location
  • Fields

Was this helpful?

  1. Transformations
  2. Transformation functions
  3. Time and Date

UTC offset

PreviousAM/PMNextTimezone

Last updated 4 years ago

Was this helpful?

Extracts the UTC offset from date values in the selected column(s).

Location

Fields

Field

Type

Description

Output column name(s)

Text field

Name of the output column(s), if left blank will save the result on the same column.

UTC offset on the interface