[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    unix_timestamp function - figured it out!
From:       "John Weber" <john () webergators ! com>
Date:       2001-01-20 3:10:50
[Download RAW message or body]


Thanks to a curiosity read of a post by John Calder about a grid i hit upon the \
following - and i said "ah hah - the unixtimestamp value is a BIGINT! - -- changed \
the ODBC setting and voila, it's working - thanks John!"

==============
BUT trick! it comes back as a "big integer" which ADO does not understand.
So

If using connection string Then
   Include ";OPTION=16386;"
ElseIf using DSN Then
   Tick the box "change BIGINT to INT"
End If
=============



[prev in list] [next in list] [prev in thread] [next in thread]