btw folks, not wanting but already hijaking the thread: I have a table with one timestamp(14) column and several other varchar(5) columns. How do I select rows from that table using two strings formated as "YYYYMMDDhhmmss" and using SQLBindParameter? I´m more interested in how setup the "SQLBindParameter" function for it. I´ve tried this many different ways already, with no sucess, so any help would be greatly appreciated.
- Mateus Begossi ----- Original Message ----- From: Peter <[EMAIL PROTECTED]> To: Jenny Christy <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, July 25, 2002 2:44 AM Subject: Re: Is type of datetime & timestamp same?? > 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. > > > > > > > --------------------------------------------------------------------- > 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
