Easy Q I haven't found written anywhere): regardin...
# gd-beginnersd
Daniel Muise
03/06/2024, 6:41 PMEasy Q I haven't found written anywhere): regarding TIMESTAMP variable formatting, what's the right format for a value?
e.g., 2024-03-06 132244 UTC
or 06/03/2024 1:22pm +00
or is this handled automatically in some way that i don't have to worry about it?
Daniel Muise
03/06/2024, 6:42 PM(currently I'm using two variables, time_date as 2024-03-06 and time_hms at 132244, of course my LDM isn't interpreting any time-of-day information as it's using only time_date for all date and time info)
f
Francisco Antunes
03/06/2024, 7:17 PMHi Daniel, in GoodData Cloud you can use the TIMESTAMP or TIMESTAMPTZ formats, which are stored in the source data as
yyyy-mm-dd HH:MM:SSd
Daniel Muise
03/06/2024, 7:18 PMGot it, thank you!
Daniel Muise
03/06/2024, 7:18 PMI assume that means the HH is in 24h format
f
Francisco Antunes
03/06/2024, 7:18 PMYes, that’s correct!
✅ 1