topic Need Date and time format like'YYYY-MM-DDT00:00:00' in App Development

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

iahmad9 — Wed, 03 Jul 2024 11:16:58 GMT

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 — Wed, 03 Jul 2024 12:22:11 GMT

@iahmad9

Try this example below:

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

- Matheus

iahmad9 — Wed, 03 Jul 2024 15:02:01 GMT

Thank you. I am getting the expected output