Home: Perl Programming Help: DBI:
timestamp from database



jsv
New User

Mar 13, 2008, 2:21 AM


Views: 5046
timestamp from database

Hi,

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 :


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 ?

Thanks,

J.