Reply To: Cloveleaf-ODBC SQL Server Interface – Data Type Issue

Homepage Clovertech Forums Read Only Archives Cloverleaf Cloverleaf Cloveleaf-ODBC SQL Server Interface – Data Type Issue Reply To: Cloveleaf-ODBC SQL Server Interface – Data Type Issue

#58864
Charlie Bursell
Participant

    In SQL Server the DateTime format is like:

        January 1, 2000

    You need an insert statement like:

       insert into mytable values (‘January 1, 2000’)

    In Tcl try:

    set dt 2006-04-25

    set fmtDt [clock format [clock scan $dt] -format “‘%B %d, %Y'”]

    # Note the returned date already has the single quotes around it

    Then just insert the $fmtDt