Re: date format problem

2004-05-03 Thread Egor Egorov
"Matt Tucker" <[EMAIL PROTECTED]> wrote: > I'm moving a JavaServlet app over from Tomcat on Win2K with a MS SQL 7 DB to Tomcat > on Red > Hat Linux with mySQL. Of course, there's about a hundred queries that use dates and > of > course, they're all in the format mm-dd-. is there a way to form

Re: Date format problem

2001-06-28 Thread MikeBlezien
On Thu, 28 Jun 2001 21:49:57 +0200, "Sebastiaan J.A. Kamp" <[EMAIL PROTECTED]> wrote: if your using perl, heres a real simple way to format your date: my $date = "28/06/2001"; my($mn,$day,$yr) = split '/',$date; my $db_date = join('-',$yr,$mn,$day); # Your output should now be $db_date = 2001-0

RE: Date format problem

2001-06-28 Thread Sebastiaan J.A. Kamp
What programming language are you using? Hi guys, does anyone help me with this simple thing ?? I have a date format problem, I need a spanish format please read the following lines: Receive from input "28/06/2001" Want to change it to "2001-06-28" to write the Database Use to do it "DATE_FORM

Re: Date format problem

2001-06-28 Thread MikeBlezien
On Thu, 28 Jun 2001 15:30:14 -0300, Alejandro Ralla <[EMAIL PROTECTED]> wrote: You would need to reformat the input date first, within your middleware, like Perl or PHP. Then you would be able to enter it into your db. >>Hi guys, does anyone help me with this simple thing ?? >> >>I have a date