get server datetime

[uoghk]

i want to get SQL database server date & time and use below coding

Set rst = db.OpenRecordset("select getdate() as servertime")

but i get error: undefined function "getdate"

[Gicu]

You'd have to use a pass-through query for that...
https://support.microsoft.com/en-us/...2-6dac62532a42

[uoghk]

Thanks Vlad Cucinschi