How to get the time from a dateTime

Hi Eric,

Use the following code, where ri!dateTime is your value of 6/27/2018 10:09 AM EDT: cast(8, local(ri!dateTime)). This should return you the time value in local timezone. If you need the raw value, just remove the local() function from the above cast.

Best,
Ashvin

Hi Eric,

Use the following code, where ri!dateTime is your value of 6/27/2018 10:09 AM EDT: cast(8, local(ri!dateTime)). This should return you the time value in local timezone. If you need the raw value, just remove the local() function from the above cast.

Best,
Ashvin

Hi Ashvin, this worked. Thank you!

Hi erickp,

In addition to Ashvin's response you can also use totime function.

totime(local(now())) -- Returns in Local Timezone

totime(now())  -- Returns in GMT Timezone