
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 05, 2022 02:30 AM
Hai everyone, how to write formula on primary key column to capture Recorded time.
I know there is column with type created time, but for primary key I’m not using so I think will be better if use for recorded time but with formula
Thank you
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 07, 2022 10:22 AM
Try
DATETIME_FORMAT(SET_TIMEZONE(NOW(), "Asia/Jakarta"),"YYYY-MM-DD -LTS")
You can find the list with supported timezone identifiers here.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 05, 2022 07:32 AM
Hi @Lucas_Tjahjadi and welcome to the community!
What do you mean by “recorded time”?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 05, 2022 06:41 PM
Hi, I mean for created time and date with time zone Asia, Jakarta.
My formula is `
DATETIME_FORMAT(NOW(),‘YYYY-MM-DD -LTS’)
but with this how to add time zone?
Could you help me for this?
Thank you

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 07, 2022 10:22 AM
Try
DATETIME_FORMAT(SET_TIMEZONE(NOW(), "Asia/Jakarta"),"YYYY-MM-DD -LTS")
You can find the list with supported timezone identifiers here.
