can convert the 14 hour military to 2 a.m EST?
Time(Date) as Date
but if what I have is the value 14 in number, I can pass it to standard time?
So just subtract 12
Can you share some sample data?
You simply define the time format as TT:
timestamp(YourTimeField, 'hh:mm TT')
=timestamp('14:00:00', 'hh:mm: TT')
returns 2:00 PM
makes sense, so TT is for Terrestrial Time
Retrieving data ...