anularity should 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 plent
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. 1254252
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 Se
>
> 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
> $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
If I'm not mistaken you should use the dateformat function (of the top
of my head)
Jack
-Original Message-
From: Shaun [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 1:54 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] DATETIME Field Query
Hi,
I had a DATE field in my table
> 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 'sn42
enerating
this error. 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: R
]
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...
jay merritt
[EMAIL PROTECTED]
[EMAIL PROTECTED
lto:[EMAIL PROTECTED]
Sent: 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 "";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forw
ROTECTED]
Sent: Thursday, June 05, 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 butt
> 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 fro
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
> 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 (http://
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
m Entertainment
(615) 287-4876
"Pay 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'; '[E
> > 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
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
ALUES ($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 s
al Message-
From: 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 s
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
> 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
Aha. That seems to work.
thanks,
bill
Charles Lahlou wrote:
> >INSERT INTO thisdb (event) VALUES ((now() + 3600);
>
> try rather VALUES (now() + INTERVAL 3600 SECOND)
>
> charles lahlou
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For
BTW,
IN SQL ANSI, these functions are standard too? Don't they?
- ADDDATE(date1, INTERVAL value UNIT)
with UNIT = SECOND, HOUR_SECOND, DAY, and so on...
- MOD(value, modulo)
and its shortcut value%modulo
- Arithmetic operators such as && + ||
- Is it Better to use <> or !=
- Is the
>INSERT INTO thisdb (event) VALUES ((now() + 3600);
try rather VALUES (now() + INTERVAL 3600 SECOND)
charles lahlou
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrat
Hi
Could you be more specific about the thing that it works only sometimes - when doesn't
it work and what happens then.
You can check and try the date_add() function but probably the problem is in your
query.
Dobromir Velev
Web Developer
http://www.websitepulse.com/
-Original Message--
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 som
27 matches
Mail list logo
