date type in ODBC

Question

Question

Stephen De Gabrielle · Feb 1, 2019

#Beginner #Databases #ObjectScript #ODBC #Caché

Hi,

I'm writing to an ODBC connection to a SQLserver database, and I seem to be sending the wrong data type to a date colum?

set tSC = ..Adapter.ExecuteUpdate(.intRows,sqlInsert,$ZDATETIME($NOW(),3,2), pRequest.ComposerName, [...])

I think `$ZDATETIME($NOW(),3,2)` is ODBC datetime format:

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fzdatetime#RCOS_fzdatetime_tformat

Do I have it wrong?

Stephen

Discussion (3)0

Log in or sign up to continue

Robert Cemper · Feb 1, 2019

$ZDATETIME($NOW(),3) should fit. You then have the Seconds too.

1 0

score 0 · Answer 1 · 2019-02-01T09:59:25-05:00

Stephen De Gabrielle · Feb 1, 2019

Awesome - thank you!

0 0

score 1 · Answer 2 · 2019-02-02T00:04:24-05:00

$Now() gives you output in different format.
ODBC date format is 3. When dformat is 3 then ODBC date separator ( '-' ) is used. For all other date format space is used as a date separator.
Instead of $Now() you can use $H also.
Ex.
1. w $ZDT($H,3)
2019-02-02 10:25:58

w $ZDT($Now(),3)
2019-02-02 10:27:20