Mar 13, 2008, 2:21 AM
Post #1 of 1
timestamp from database
I am getting a date from the database using perl script. The date is stored in the database table with its timestamp. I could get the date but not the timestamp. How can I get the timestamp with that date ?
I am using DBI to get the data from database.Here is code :
use DBI;$sth = $db->prepare(" SELECT l.updated_date FROM
lms_letter l where l.letter_id = ? ");$sth->execute($lms_id); my @results = $sth->fetchrow_array(); $sth->finish();
Can anyone help me on this please ?