Re: Converting date in MySQL

2004-10-14 Thread Jeff Smelser
On Thursday 14 October 2004 04:00 pm, Mike Johnson wrote: > It does matter, though. You can't use DATE_FORMAT() to translate > '10/14/2004' into '2004-10-14.' No, your right, that would be wrong. > It looks like what the poster wants is STR_TO_DATE() (a la > STR_TO_DATE('10/14/2004', '%m/%d/%Y'),

RE: Converting date in MySQL

2004-10-14 Thread Mike Johnson
From: Jeff Smelser [mailto:[EMAIL PROTECTED] > On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote: > > No :),. cause it seems that those formats are for > > outbound, db ->. > > I was looking for the other direction. > > Huh? It really doesnt matter does it? They work either way.. >

Re: Converting date in MySQL

2004-10-14 Thread Jeff Smelser
On Thursday 14 October 2004 03:46 pm, [EMAIL PROTECTED] wrote: > 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 c

Re: Converting date in MySQL

2004-10-14 Thread SGreen
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 "-MM-DD hh:nn:s

Re: Converting date in MySQL

2004-10-14 Thread Jeff Smelser
On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote: > No :),. cause it seems that those formats are for > outbound, db ->. > I was looking for the other direction. Huh? It really doesnt matter does it? They work either way.. I use those functions all the time for inbound.. Jeff pgps

Re: Converting date in MySQL

2004-10-14 Thread Stuart Felenstein
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 y

Re: Converting date in MySQL

2004-10-14 Thread Jeff Smelser
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 pgpSsmcBOJscM.pgp Description: PGP signature

Re: Converting date in MySQL

2004-10-14 Thread Stuart Felenstein
Thanks , I know the page and have the links bookmarked! Stuart --- Jeff Smelser <[EMAIL PROTECTED]> wrote: > On Thursday 14 October 2004 02:45 pm, Stuart > Felenstein wrote: > > > Apparently, mysql does not like the format > > "MM/DD/" > > Then again I tried it around , still no dice. > > I

Re: Converting date in MySQL

2004-10-14 Thread Jeff Smelser
On Thursday 14 October 2004 02:45 pm, Stuart Felenstein wrote: > Apparently, mysql does not like the format > "MM/DD/" > Then again I tried it around , still no dice. > It's intended to go into a Date" column. http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html All, you every need

Converting date in MySQL

2004-10-14 Thread Stuart Felenstein
Hi, I am taking user input via a calendar widget (guess it's js) Apparently, mysql does not like the format "MM/DD/" Then again I tried it around , still no dice. It's intended to go into a Date" column. Is there a way I can correct it right within my query ? Stuart -- MySQL General Mail