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

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 1161 views
  • 0 likes
  • 2 in conversation