CODEWITHSUNDEEP
sqlms-access
Rick
Rick

Reputation: 2308

Access: convert numerical date

I have table where the date field (TimeStringID ) is in numerical format represented as the number of seconds that have past since 12:00am March 1,1980.

In SQL Server the command is DATEADD(s, CAST(TimeStringID AS numeric), '1980-03-01') AS 'StartTime'

The field 1289260817.0000000501 converts to 2021-01-07 00:00:17.000 using the above SQL Server statement.

How would I convert this for Access queries?

Upvotes: 0

Views: 57

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269753

I believe this is the equivalent:

 select dateadd("s", TimeStringId, #03/01/1980#)

Upvotes: 2

Related Questions