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.
not be an issue.
Thanks all
Edward
-Original Message-
From: Jason Gerfen [mailto:jason.ger...@scl.utah.edu]
Sent: Thursday, October 08, 2009 4:09 PM
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] DATETIME
Go look at dev.mysql.com and search for DATETIME. There are plenty of
examples of how
$month_start : starting month
$month_end : ending month
$day_start : starting day
$day_end : ending day
You could add something like this in the WHERE clause:
((MONTH(closing) = $month_start AND DAY(closing) = $day_start)
AND
(MONTH(closing) = $month_end AND DAY(closing) = $day_end))
--
PROTECTED]
Subject: Re: [PHP-DB] Datetime help in an INSERT...
I am stumbling across something that I thought I have done before,
and I am not having any luck finding an example of this. Basically, I
am
wanting to timestamp the date and time into new entries in a simple
database
table
I have actually discovered that the $td value is blank. The reason
appears to be that the page is reloading when a button is pushed, and that
is when the $td value is being lost. My question now is, how do I keep
the
$td value after the page is reloaded? I would rather keep the value from
, 2003 9:06 AM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Datetime help in an INSERT...
I have actually discovered that the $td value is blank. The reason
appears to be that the page is reloading when a button is pushed, and that
is when the $td
: Thursday, June 05, 2003 9:01 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Datetime help in an INSERT...
You could alway place it as a GET
echo a href=\yourscript.com/yourpage.php?td=$td\;
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto
]
Sent: Thursday, June 05, 2003 9:48 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: [PHP-DB] Datetime help in an INSERT...
a button is being pressed?
so it is processing a form?
if its in a form just pass along the value of $td via hidden input data...
input type=hidden name=td value=? echo $td; ?
jay
. I am guessing that you guys will need more info to help out
with this now. Just let me know what you want. Thanks again.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:07 AM
To: NIPP, SCOTT V (SBCSI)
Subject: Re: [PHP-DB] Datetime
I am now getting a completely different error that I cannot
figure
out how it is related. I have passed the $td variable into the
function
and
then get it back as a POST variable from a hidden field within the
function.
Here is the error I am now seeing;
Unknown column 'sn4265' in
The error I am receiving is:
You have an error in your SQL syntax near ' NOW())' at line 1
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:45 PM
To: NIPP, SCOTT V (SBCSI)
Subject: Re: [PHP-DB] Datetime help in an INSERT
: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:47 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT...
The error I am receiving is:
You have an error in your SQL syntax near ' NOW())' at line 1
($tmp, $td );
Randy
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT...
If you are using MySql with the date field is of type timestamp, you should
have to insert
No, the field is a Datetime field rather than a Timestamp field.
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:59 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT...
Correction ( I typed
I am stumbling across something that I thought I have done before,
and I am not having any luck finding an example of this. Basically, I
am
wanting to timestamp the date and time into new entries in a simple
database
table. The following section is the actual code for this, and I cannot
It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 2:06 PM
To: 'Rankin, Randy'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT
far.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 2:14 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Datetime help in an INSERT...
I am stumbling across something that I thought I have
2. Place single quotes within your VALUES parens, e.g.
If they are really strings. Integers or dates in a MMDD format do not
require quotes.
$denylog = INSERT INTO deny (account, td, datefield ) VALUES ('$tmp',
'$td', NOW() )
---John Holmes...
--
PHP Database Mailing List
hello and thank you... probably again.
using datetime, /or something else if applicable, is it possible to
have entries to a page and entries to a db automatically delete? i
have looked through many docs at php.net and mysql and can't find
anything. perhaps i'm using the wrong search key
This problem has just been fixed in CVS.
- Frank
Hello!
How can I force PHP to fetch datetime field i 'mmdd hh:mm:ss' WITHOUT
using MSSQL query like *SELECT convert(varchar,dtfield,20) as 'dtfield'* and
so on?
I have a few tables on MSSQL with the different structures and some of
22 matches
Mail list logo
