I would like to convert date to time by Query

Question & Answer
1

Hi All,

i would like to convert date to time by Query.

Now i use this syntax.

  DATE(CAST(From_iso8601_timestamp(ap.Payment_Datetime__c) AS timestamp) AT TIME ZONE 'Asia/Singapore') AS payment_date,

and i got this data

image

i would like to get data like payment_date_original (date type)

image

Many Thanks

2

Hi All,

i already did it !!!

CAST(FROM_ISO8601_TIMESTAMP(ap.Payment_Datetime__c) as timestamp) AS payment_date_time,

image

Many Thanks.