extremeguy Posted December 16, 2003 Share Posted December 16, 2003 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! Quote Link to comment Share on other sites More sharing options...
gizmola Posted December 16, 2003 Share Posted December 16, 2003 Try something like: SELECT *, DATE(ts) as tsdate, TIME(ts) as tstime FROM table Quote Link to comment Share on other sites More sharing options...
extremeguy Posted December 16, 2003 Author Share Posted December 16, 2003 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 Quote Link to comment Share on other sites More sharing options...
extremeguy Posted December 18, 2003 Author Share Posted December 18, 2003 Am I going about this all wrong? Should I be storing the values as a UNIX timestamp instead of YYYYMMDDHHMM ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.