Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Datetime problem
0 views
Skip to first unread message
Cédric PACHOUD
Jul 17, 2002, 10:13:25 AM7/17/02
to
I insert data into my MySQL database and I write the same string into a
textfile.
Every thing is Ok excepted the time ( my field is a TimeStamp ) and in my
Query I affect the value with the AsDateTime property.
textfile.
Every thing is Ok excepted the time ( my field is a TimeStamp ) and in my
Query I affect the value with the AsDateTime property.
For example :
Textfile : 17/07/2002 18:33:11
DB : 17/07/2002 18:34:33
Can anybody help me ?
David Gagnon
Jul 17, 2002, 5:21:14 PM7/17/02
to
Make sure your client machine and server have the same time.
"Cédric PACHOUD" <ced...@pachoud.com> wrote in message
news:3d3579b4$0$277$626a...@news.free.fr...
Dan Brennand
Jul 17, 2002, 6:31:10 PM7/17/02
to
On Wed, 17 Jul 2002 17:21:14 -0400, "David Gagnon"
<dga...@chartermi.net> wrote:
<dga...@chartermi.net> wrote:
>Make sure your client machine and server have the same time.
>
Also, make sure you are reading the clock only once. For example,
don't set the value in the textfile by using NOW, and then set the
value in the DB by using NOW again. Use a datetime variable and set it
only once so you get identical values in both places.
hth,
Dan
0 new messages