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-06-28
Hope this helps ;)
>>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_FORMAT (inputdate, %Y-%m-%d)"
>>
>>It doesn't work fine
>>
>>Thanks a lot for your time
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
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
