[PHP] Re: Date Function - Empty Value

2004-05-20 Thread Gabe
Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Torsten Roehr wrote: "Gabe" <[

Re: [PHP] Re: Date Function - Empty Value

2004-05-20 Thread Gabe
Mark Pecaut wrote: On Thu, May 20, 2004 at 12:28:00PM -0400, Gabe wrote: I'm trying to store a date in a date/time field using the short date format ( m/d/ ). For some reason it won't let me post an empty value to that field in the DB. I've tried using empty quotes ( "" ) I'm using Microsoft

Re: [PHP] Re: Date Function - Empty Value

2004-05-20 Thread Mark Pecaut
On Thu, May 20, 2004 at 12:28:00PM -0400, Gabe wrote: > >>I'm trying to store a date in a date/time field using the short date > >>format ( m/d/ ). For some reason it won't let me post an empty > >>value to that field in the DB. I've tried using empty quotes ( "" ) > > I'm using

[PHP] Re: Date Function - Empty Value

2004-05-20 Thread Torsten Roehr
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Torsten Roehr wrote: > > "Gabe" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > >>Torsten Roehr wrote: > >> > >> > >>>"Gabe" <[EMAIL PROTECTED]> wrote in message > >>>news:[EMAIL PROTECTED] > >>> > >>> >

[PHP] Re: Date Function - Empty Value

2004-05-20 Thread Gabe
Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Environment: PHP 4.3.6 Access D

[PHP] Re: Date Function - Empty Value

2004-05-19 Thread Torsten Roehr
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Torsten Roehr wrote: > > > "Gabe" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > >>Torsten Roehr wrote: > >> > >> > >>>"Gabe" <[EMAIL PROTECTED]> wrote in message > >>>news:[EMAIL PROTECTED] > >>> > >>> > >>

[PHP] Re: Date Function - Empty Value

2004-05-19 Thread Torsten Roehr
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Torsten Roehr wrote: > > > "Gabe" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > >>Environment: > >>PHP 4.3.6 > >>Access DB > >>W2K IIS 5 > >> > >> > >>I'm trying to store a date in a date/time field using t

[PHP] Re: Date Function - Empty Value

2004-05-19 Thread Gabe
Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Environment: PHP 4.3.6 Access DB W2K IIS 5 I'm trying to store a date in a date/time field using the short date format (

Re: [PHP] Re: Date Function - Empty Value

2004-05-19 Thread Gabe
Matt Matijevich wrote: [snip] Well, I would, but I can't seem to figure out how to export just the structure out of access. Wouldn't NULL be allowed by default? [/snip] Do you have access to the mdb file? If you do you can just go into design view of the table to find out the data definitions.

[PHP] Re: Date Function - Empty Value

2004-05-19 Thread Matt Matijevich
[snip] Well, I would, but I can't seem to figure out how to export just the structure out of access. Wouldn't NULL be allowed by default? [/snip] Do you have access to the mdb file? If you do you can just go into design view of the table to find out the data definitions. -- PHP General Mailin

[PHP] Re: Date Function - Empty Value

2004-05-19 Thread Gabe
Torsten Roehr wrote: "Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Environment: PHP 4.3.6 Access DB W2K IIS 5 I'm trying to store a date in a date/time field using the short date format ( m/d/ ). For some reason it won't let me post an empty value to that field in the DB.

[PHP] Re: Date Function - Empty Value

2004-05-19 Thread Torsten Roehr
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Environment: > PHP 4.3.6 > Access DB > W2K IIS 5 > > > I'm trying to store a date in a date/time field using the short date > format ( m/d/ ). For some reason it won't let me post an empty > value to that field in the DB. I'

[PHP] Re: Date Function in Php

2002-05-16 Thread Baba Buehler
Vinod Palan wrote: > hi , > Do any one have date functions like that we have in asp 1) Dateadd() > 2) Datediff() > etc? There are some classes in PEAR that may do what you want, take a look at Date & Date::Calc. baba -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: ht

[PHP] Re: Date Function in Php

2002-05-15 Thread George Nicolae
try mktime() function. -- Best regards, George Nicolae IT Manager ___ PaginiWeb.com - Professional Web Design www.PaginiWeb.com "Vinod Palan" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > hi , > Do any one have date functions like that we

[PHP] Re: Date function

2002-04-19 Thread Henrik Hansen
[EMAIL PROTECTED] (Alia Mikati) wrote: > Hello > I have the following SQL and I wanna insert the current date in one of > the table fields but it's not working. Can u tell me whats the problem? > (I'm using mysql and php) > Thx a lot > > $SQL = "INSERT INTO orders (Customer_Id, Order_Date