Hi all,
we used the bind_param function to insert a lot of integers into our
database. As I just found out now quite a few of them were bigints, and
did not end up correctly in the database, because the integer parameter
supports only integers up to 2^32.
Now my question: Anybody know how I
Hi All,
I have a DB that is storing the date/time an event happens in DATETIME format,
i.e. 1254252889, which translates to Tue, 29 Sep 2009 19:34:49 UTC
I am trying to write a query in PHP that will look for any row that falls
within a range of dates, i.e. between Sep 1 and Oct 1, but
Hi All,
I have a DB that is storing the date/time an event happens in DATETIME
format, i.e. 1254252889, which translates to Tue, 29 Sep 2009 19:34:49 UTC
I am trying to write a query in PHP that will look for any row that falls
within a range of dates, i.e. between Sep 1 and Oct 1, but
Go look at dev.mysql.com and search for DATETIME. There are plenty of
examples of how to do comparison searching using the UNIX datestamps.
Dan Shirah wrote:
Hi All,
I have a DB that is storing the date/time an event happens in DATETIME
format, i.e. 1254252889, which translates to Tue, 29
Sorry I should have included a simple example:
SELECT (`field_01`, `field_02`) FROM `table` WHERE DATETIME('2009-09-01
00:00:00.000') DATETIME('2009-10-01 23:59:59.999');
Dan Shirah wrote:
Hi All,
I have a DB that is storing the date/time an event happens in DATETIME
format, i.e.
Thanks all - yes this is mysql, but not a mysql DATETIME field per se, but the
issue was that I was trying to do like or equal to query the date range, and
doing that will never match since whats in the db is MMDDHHMM (in
timestamp format) and yet the query I would be able to send would
