Jump to content

Archived

This topic is now archived and is closed to further replies.

extremeguy

DATE/TIMESTAMP Question

Recommended Posts

I have a MySQL database table with a field that is of type TIMESTAMP(12). When I do a query, I get the result back as YYYYMMDDHHMM as expected. The syntex of my query is \"SELECT * FROM rv\". I am obviously using PHP and I am trying to take the result and split it up into 2 arrays, one for date and one for time (ie. $date == $date[0]=YYYY, $date[1]=MM, $date[2]=DD and $time == $time[0]=HH, $time[1]=mm). WHat is the easiest way to accomplish this?

 

I have also thought about trying to get the info from within my query, BUT I am using \"SELECT *\" and have not found a way to use \" * \" and request specific formated dates or times. I would rather stick with selecting \" * \" instead of spelling it all out in the query b/c there are 20+ fields of info that I need.

 

Thanks in advance for the help!

Share this post


Link to post
Share on other sites

Try something like:

 

SELECT *, DATE(ts) as tsdate, TIME(ts) as tstime FROM table

Share this post


Link to post
Share on other sites
Try something like:

 

SELECT *, DATE(ts) as tsdate, TIME(ts) as tstime FROM table

 

I just tried this and it didn\'t work.

 

This is the SQL query that I am using: SELECT *, DATE(rv_arrive) as arrive_date, TIME(rv_arrive) as arrive_time FROM rt_rv WHERE rv_key=1001

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.