Welcome Guest, Not a member yet? Register   Sign In
Parsing datetime from MySQL
#11

[eluser]lenwood[/eluser]
I think I answered my own question about the last param. From noctum:

[quote author="noctrum" date="1270757078"]Prevents active record from trying to escape field names, which is almost always necessary with complicated queries.

http://ellislab.com/codeigniter/user-gui...ecord.html[/quote]
#12

[eluser]Zeeshan Rasool[/eluser]
Quote:@lenwood Now that you see how I’m accessing the data, do you still think it would be better to use SQL statements for the date & time?

I think if you use mysql function then you can do this whole process easily. If you need date in some other format then just add your format in query. As my experience its very good approach and no need to put php functions involved any more.
@mddd is showing the way to get date and time in mysql query.




Theme © iAndrew 2016 - Forum software by © MyBB