Posted 16 December 2003 - 08:47 PM
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!
Posted 16 December 2003 - 09:05 PM
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
Posted 18 December 2003 - 02:47 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users