Getting time and date from timestamp with php

Question

in my database I have a time stamp column   which reflects a format like this  2012-04-02 02 57 54  However I would like to separate them up into  date and  time   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     In my php file   the timestamp extracted would be  row  DATETIMEAPP      Will   date  strtotime  d-m-Y   row  DATETIMEAPP      time  strtotime  Gi s   row  DATETIMEAPP       or   date  date  d-m-Y   row  DATETIMEAPP       work   Can i use date   to get the time as well    Thanks in advance

User · Accepted Answer

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     Alternatively  list  date   time    explode      date  d-m-Y Gi s    timestamp

User · Answer

You can try this   For Date    date   new DateTime  from date    date    date- gt format  d-m-Y      For Time    time   new DateTime  from date    time    time- gt format  H i s

User · Answer

Works for me   select DATE  FROM UNIXTIME  columnname     from tablename

User · Answer

timestamp  2014-11-21 16 38 00    list  date  time  explode      timestamp        just time  preg match      d d  d d   d d     timestamp  match   echo   n lt br gt    match 1

User · Answer

Optionally you can use database function for date time formatting  For example in MySQL query use   SELECT DATE FORMAT DATETIMEAPP   d- m- Y   AS date  DATE FORMT DATETIMEAPP   H  i  s   AS time FROM yourtable   I think that over databases provides solutions for date formatting too

User · Answer

mydatetime    2012-04-02 02 57 54    datetimearray   explode       mydatetime    date    datetimearray 0    time    datetimearray 1    reformatted date   date  d-m-Y  strtotime  date     reformatted time   date  Gi s  strtotime  time

User · Answer

If you dont want to change the format of date and time from the timestamp  you can use the explode function in php   timestamp    2012-04-02 02 57 54   datetime   explode      timestamp    date    datetime 0    time    datetime 1

[php] Getting time and date from timestamp with php

Examples related to php

Examples related to date

Examples related to time

Examples related to timestamp