Need Date and time format like'YYYY-MM-DDT00:00:00'

[iahmad9]

Hi Team,

I am pulling data from REST API. I am planning to use incremental load but my api YTMDATE date coming like blow.

YTMDATE

'2021-01-31T00:00:00'

I am trying to calculate max date but date format getting change.

MAX(Timestamp(YTMDATE,'YYYY-MM-DDThh:mm:ss')) AS MaxYTMDATE

I would like to request you Please help on this.

Irshad Ahmad

[MatheusC · Accepted solution]

@iahmad9 

Try this example below:

Replace(timestamp(max(DateTime),'YYYY-MM-DD hh:mm:ssZ'),' ','T') as MaxDateTime 

 
- Matheus

[iahmad9]

Thank you. I am getting the expected output