• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to insert a date into the database?

#5
[eluser]jedd[/eluser]
That's going to be nice and fast if you're just doing comparisons between two dates, but I think you get some measurable performance benefits once you start using the native date and time types - for example selecting a bunch of records from a given month. Sure, you can work out your boundaries for each month, but then you end up with a bunch of new functions, and a bit of overhead.

There are CI/php functions to convert 8601 / MySQL date formats back into unix time (number of seconds since 19700101T0000UTC Wink


Messages In This Thread
how to insert a date into the database? - by El Forum - 09-19-2009, 10:41 AM
how to insert a date into the database? - by El Forum - 09-19-2009, 11:31 AM
how to insert a date into the database? - by El Forum - 09-19-2009, 06:02 PM
how to insert a date into the database? - by El Forum - 09-19-2009, 06:26 PM
how to insert a date into the database? - by El Forum - 09-19-2009, 07:29 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.