For values headed into a SQL statement, use whatever functions are available to you in the language (PHP, PERL, Python, Java, VB Script,...) you are using to accept the user's input in order to make the commands you send MySQL correct. You just need to convert the date into "YYYY-MM-DD hh:nn:ss" format and MySQL will be as happy as a clam.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Stuart Felenstein <[EMAIL PROTECTED]> wrote on 10/14/2004 04:35:21 PM: > No :),. cause it seems that those formats are for > outbound, db ->. > I was looking for the other direction. > > Stuart > --- Jeff Smelser <[EMAIL PROTECTED]> wrote: > > > On Thursday 14 October 2004 03:12 pm, Stuart > > Felenstein wrote: > > > Thanks , I know the page and have the links > > > bookmarked! > > > > So you got the answer from it right? > > > > Jeff > > > > > ATTACHMENT part 2 application/pgp-signature > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
