Skip to content

:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.

1.8 KB
Raw Blame
import { HogFunctionTemplate } from '~/cdp/types'

export const template: HogFunctionTemplate = {
    free: true,
    status: 'stable',
    type: 'transformation',
    id: 'template-timestamp-parser',
    name: 'Timestamp Parser',
    description:
        'Parses the event timestamp into separate day of the week, day, month, year, hour and minute properties.',
    icon_url: 'https://res.cloudinary.com/dmukukwp6/image/upload/q_auto,f_auto/builder_hog_01_955c082cad.png',
    category: ['Custom'],
    code_language: 'hog',
    code: `
if (empty(event.timestamp)) {
    return event
}

let returnEvent := event
let ts := event.timestamp
let dt := null

if (typeof(ts) == 'string') {
    dt := toDateTime(ts)
} else if (typeof(ts) == 'integer' or typeof(ts) == 'float') {
    // 9999999999 seconds is year 2286, so any larger value is milliseconds. This keeps
    // millisecond timestamps from before 2001 from being read as far-future second timestamps.
    dt := ts > 9999999999 ? fromUnixTimestampMilli(ts) : fromUnixTimestamp(ts)
}

// A string that is not a real timestamp still yields a DateTime, so check that a date part comes
// back as a real number before writing anything. An unparseable timestamp gives null or NaN, and
// NaN fails self-equality, so both are rejected here and no junk properties are written.
let year := dt != null ? extract('year', dt) : null
if (year != null and year == year) {
    returnEvent.properties['day_of_the_week'] := formatDateTime(dt, '%W')
    returnEvent.properties['day'] := extract('day', dt)
    returnEvent.properties['month'] := extract('month', dt)
    returnEvent.properties['year'] := year
    returnEvent.properties['hour'] := extract('hour', dt)
    returnEvent.properties['minute'] := extract('minute', dt)
}

return returnEvent
    `,
    inputs_schema: [],
}