Hi Jenny, The formatting are the same YYYY-MM-DD HH: -----
The timestamp field is set automatic by the system when updating a record. The date/time fields are for Your control and usage. Take a look in the manual 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types Best regards Peter ----- Original Message ----- From: "Jenny Christy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, July 25, 2002 6:22 AM Subject: Is type of datetime & timestamp same?? > Hello All, > I m using mysql 3.23.42 and myodbc 3.51 on linux7.2. > I use SQLDescribeCol API to get type of column(field). > When i call above functuon it returns type of datetime > and timestamp is 93 for both. but the format of > inserting datetime value uses ( " " )and timesstamp > value is different. > I m having a problem how can I distinguish them so > that I can insert the data in correct format.or is > there any bug in myodbc driver. > Thanx in advance for ur kind help. > > Rgds, > Jenny > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
