Table of Contents
...
Paste code macro |
---|
SELECT dbo.localizedate (DateTime, 'Zip code'); |
Change DateTime to the datetime needing to be localized, and ZipCode to the zip code to use to determine the timezone for localizing the datetime value. Using the statement above will result in a YY-MM-DD hh:mm:ss.s. For example, the date output would be 2020-09-04 17:17:20.887.
...