MySQL Date Question......help please.

[amerar]

Hi All,
I want to convert a date......
I am given the Day of the Week, plus the Hour and Minute. I want to
convert that into a YYYY-MM-DD HH:MI format so I can store it and sort
it in the database.
The only think I know is the beginning of the week date, and the end of

the week date.......
Can anyone help?
PS: I'm writing a script in Perl............
Thanks,
Arthur

[Andy Hassall]

On 9 Jan 2006 13:32:04 -0800, am****@iwc.net wrote:

PS: I'm writing a script in Perl

Wrong newsgroup then, try comp.lang.perl.misc.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Michael Austin]

am****@iwc.net wrote:

Hi All,
I want to convert a date......
I am given the Day of the Week, plus the Hour and Minute. I want to
convert that into a YYYY-MM-DD HH:MI format so I can store it and sort
it in the database.
The only think I know is the beginning of the week date, and the end of

the week date.......
Can anyone help?
PS: I'm writing a script in Perl............
Thanks,
Arthur

google -- perl date format
and mysql date format
will give you what you are looking for.
--
Michael Austin.

[Pedro Graca]

am****@iwc.net wrote:

I want to convert a date......
I am given the Day of the Week, plus the Hour and Minute. I want to
convert that into a YYYY-MM-DD HH:MI format so I can store it and sort
it in the database.
The only think I know is the beginning of the week date

Ok, that's enough :)

If the Day of the Week you're given is Monday add 0 to the beginning of
the week date; if it's Tuesday, add 1; Wednesday, add 2; ...

Adjust at will if your week doesn't start on Mondays.

--
Mail to my "From:" address is readable by all at http://www.dodgeit.com/
== ** ## !! ------------------------------------------------ !! ## ** ==
TEXT-ONLY mail to the whole "Reply-To:" address ("My Name" <my@address>)
may bypass my spam filter. If it does, I may reply from another address!