Thanks all,
I got it working.
-Original Message-
From: $Bill Luebkert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 24, 2004 11:38 PM
To: Viswanatha Rao
Cc: [EMAIL PROTECTED]
Subject: Re: date calculation perl and mysql
Viswanatha Rao wrote:
> DateTime is in -MM-DD HH:MM
> Hy ... which module is playing here?
>
use DBI;
only ;-) All is the MySQL keywords.
Petr Vileta, Czech republic
___
ActivePerl mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
If you pick it up from mysql, use the UNIX_TIMESTAMP [1]
function. It converts a mysql datetime type into seconds
since 1970. You can then do your math on it.
Otherwise, I suggest looking at the datetime modules [2].
-Mathieu
[1]
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
[2