RE: date calculation perl and mysql

2004-08-25 Thread Viswanatha Rao
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

Re: date calculation perl and mysql

2004-08-25 Thread Petr Vileta
> 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

Re: date calculation perl and mysql

2004-08-25 Thread Mathieu Longtin
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