使用php从时间戳获取时间和日期

2022-01-13 00:00:00 time timestamp date php

在我的数据库中,我有一个时间戳列...它反映了如下格式:2012-04-02 02:57:54

in my database I have a time stamp column...which reflects a format like this: 2012-04-02 02:57:54

但是我想将它们分成 $date$time.

However I would like to separate them up into $date and $time.

通过 php 手册进行一些研究后...我发现 date() 、 date_format() 和 strtotime() 能够帮助我将它们分开...(不确定我是否正确)

after some research through the php manual...I found that date() , date_format() and strtotime() are able to help me to separate them...(not sure if I am right)

但我不太清楚如何编码...

but I not very sure of how to code it out...

在我的 php 文件中...提取的时间戳将是 $row['DATETIMEAPP'].

In my php file...the timestamp extracted would be $row['DATETIMEAPP'].

$date= strtotime('d-m-Y',$row['DATETIMEAPP']);
$time= strtotime('Gi.s',$row['DATETIMEAPP']);

$date= date('d-m-Y',$row['DATETIMEAPP']);

工作?

我也可以使用 date() 来获取时间吗??

Can i use date() to get the time as well??

提前致谢

推荐答案

$timestamp = strtotime($row['DATETIMEAPP']);

给你时间戳,然后你可以使用日期来格式化:

gives you timestamp, which then you can use date to format:

$date = date('d-m-Y', $timestamp);
$time = date('Gi.s', $timestamp);

或者

list($date, $time) = explode('|', date('d-m-Y|Gi.s', $timestamp));

相关文章