At 12:56 PM 7/30/01 -0500, David Simcik wrote:
>Hey folks,
> I'm about to embark on some serious beginner date manipulation
> and I was
>wondering if anybody had ANY pointers about handling dates. I'm specifically
>interested in working with the different date formats DD/MM/YYYY,
>MM/DD/YYYY, Dec 12 2000, etc. etc.
Check out Date::Manip and Date::Parse.
>What about working with the DATE datatype
>for Oracle and MySQL via DBI???
Not really an issue in my experience; just make sure that when you put a
date in that it's in the expected format and it just looks like a
string. You can change what's expected in Oracle with something like
alter session set nls_date_format = 'YYYYMMDDHH24:MI:SS'
Dunno what MySQL expects but it can't be significantly different. Of
course, if you want to do date comparison in your program on dates
retrieved from the database, either do the comparison in the SQL, or use
Date::Parse to turn into Unix time, or store the dates as Unix times to
begin with (not a solution I've ever employed).
--
Peter Scott
Pacific Systems Design Technologies
http://www.perldebugged.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
