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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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