BookmarkSubscribeRSS Feed
DME790
Pyrite | Level 9

Hi all,

 

Trying to convert GMT time to AEDT.

 

Time Zone InformationTime Zone NameRegionTime Zone DescriptionTime Zone Offset

Australia/ACT
AEST
AU
Australian Eastern Time
10:00
Australia/ACT
AEDT
AU
Australian Eastern Daylight Time
11:00

 

My dates are a datetime stamp

 

CALL_DTS
02DEC18:13:00:00
02DEC18:13:00:00
02DEC18:13:00:00
02DEC18:13:01:00
02DEC18:13:01:00
02DEC18:13:01:00
02DEC18:13:01:00
02DEC18:13:02:00
02DEC18:13:02:00
02DEC18:13:02:00

 

 

 

I have tried 

AEDT = intnx('hour',CALL_DTS,AEDT,'s');

but getting errors.

 

any help appreciated

 

 

regrads

 

Dean

 

 

 

 

 

  
1 REPLY 1
PGStats
Opal | Level 21

If you have access to National Language Support:

 

AEDT = TZONEU2S(CALL_DTS, "AEDT");

PG

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1237 views
  • 0 likes
  • 2 in conversation