Store Timestamp / Retrieve TimeStamp / Convert Timestamp to date

phpnewbie34

Good morning friends and programmers,

I am looking for a method to:

1) Store the current timestamp in a variable
2) Send the timestamp to the database
3) Retrieve the timestamp
4) Convert to a date again

xerxes

If you're using it within an insert or update command, there's little point assigning it to a variable, instead do something like this:

PDO

$pdo = $connDB->prepare("INSERT INTO tbl_Name(Something,SomethingElse,SomeDate) VALUES (?,?,NOW())");
$pdo->execute(array($intSomething,$strSomethingElse));

mysqli

$stmt = $mysqli->prepare("INSERT INTO tbl_Name(Something,SomethingElse,SomeDate) VALUES (?,?,NOW())");
$stmt->bind_param('is', $intSomething, $strSomethingElse);
$stmt->execute(); 
$stmt->close();

To dispalay a timestamp as DD/MM/YYYY

$datSomeDate = strftime("%d/%m/%Y", strtotime($datSomeDate ));

bradgrafelman

xerxes;11027165 wrote:
To dispalay a timestamp as DD/MM/YYYY
$datSomeDate = strftime("%d/%m/%Y", strtotime($datSomeDate ));

Or simply request the DB give you the timestamp in whatever format you prefer; example using MySQL's DATE_FORMAT():

SELECT DATE_FORMAT( dateCol, '%d/%m/%Y' ) AS formattedDate, ...