in reply to Re^4: Create a search by date in a unix timestamp data
in thread Create a search by date in a unix timestamp data

Ok, now, look at my code, in the first post. In my select, i save the "timestamp" value in the var "$timestamp", and list it in "while", my question is, how to print this twice, 1 with date, and 1 with hour?

Really? If that is your question, you write

my $timestamp = '2012-05-11 06:55:36';

How do I print $timestamp twice?

The answer is  print $timestamp, $timestamp;

Does that answer your question?