Re: [PHP-WIN] Date question?

2003-09-17 Thread Jim Hunter
Check out the PHP manual on date formatting: http://us2.php.net/date Jim ---Original Message--- From: Harpreet Date: Wednesday, September 17, 2003 02:36:49 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-WIN] Date question? I have a field in my sql server called expiration which is of

Re: [PHP-WIN] Date question?

2003-09-17 Thread Harpreet
I have a field in my sql server called expiration which is of type datetime. It has values as seen in the tables and query analyser as 1/1/01 2:11:11 PM When i try to display the same value in a php page it shows as Jan 1 2001 2:11PM How can i view the same format as seen the database on my php

Re: [PHP-WIN] Date question?

2003-09-17 Thread Harpreet
i supposed > 2003-04-02 to mean February 4th 2003 if i'm wrong you have to change the > mktime line.. > > - Original Message ----- > From: "Disko_kex" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, September 12, 2003 3:50 PM > Subj

Re: [PHP-WIN] Date question?

2003-09-12 Thread malte
Sent: Friday, September 12, 2003 3:50 PM Subject: [PHP-WIN] Date question? > Hi > > If I have a date (2003-04-02) and want to select 9 months later, how to > do? > > Thanks. > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://ww

RE: [PHP-WIN] Date question?

2003-09-12 Thread Svensson, B.A.T. (HKG)
>> [EMAIL PROTECTED] bats]$ echo date("Y-m-d",strtotime("2003-04-02 +9 >> month")); >> bash: syntax error near unexpected token `(' >> [EMAIL PROTECTED] bats]$ > >Please tell: how do you get this stuff on Windows? CygWIN -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-WIN] Date question?

2003-09-12 Thread George Pitcher
> >> If I have a date (2003-04-02) and want to select 9 months later, > >> how to do? > >> > > > >Try this: > > > >echo date("Y-m-d",strtotime("2003-04-02 +9 month")); > > [EMAIL PROTECTED] bats]$ echo date("Y-m-d",strtotime("2003-04-02 +9 > month")); > bash: syntax error near unexpected token `(

RE: [PHP-WIN] Date question?

2003-09-12 Thread Svensson, B.A.T. (HKG)
>> If I have a date (2003-04-02) and want to select 9 months later, >> how to do? >> > >Try this: > >echo date("Y-m-d",strtotime("2003-04-02 +9 month")); [EMAIL PROTECTED] bats]$ echo date("Y-m-d",strtotime("2003-04-02 +9 month")); bash: syntax error near unexpected token `(' [EMAIL PROTECTED] ba

RE: [PHP-WIN] Date question?

2003-09-12 Thread Svensson, B.A.T. (HKG)
Well you open up yuor agenda and turn the apropriate pages backwards, or did you intend a certain system? -Original Message- From: Disko_kex To: [EMAIL PROTECTED] Sent: 9/12/03 3:50 PM Subject: [PHP-WIN] Date question? Hi If I have a date (2003-04-02) and want to select 9 months later

Re: [PHP-WIN] Date question?

2003-09-12 Thread Erwin Kerk
If I have a date (2003-04-02) and want to select 9 months later, how to do? Try this: echo date("Y-m-d",strtotime("2003-04-02 +9 month")); Erwin Kerk WebDeveloper -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-WIN] Date question?

2003-09-12 Thread Disko_kex
Hi If I have a date (2003-04-02) and want to select 9 months later, how to do? Thanks. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-WIN] date question

2003-08-14 Thread Harpreet
I use the below sql statement to add one day to the date select DATEADD(day,1,'2003-08-11 23:59:59') as datered It returns $expir="Aug 12 2003 11:59PM" To convert the format to -MM-DD I use $expir=date('Y-m-d', $expir); The new value returned is 1969-12-31. What am i doing wrong. The only t

RE: [PHP-WIN] Date question

2003-06-24 Thread John Ellingsworth
PROTECTED] Sent: Tuesday, June 24, 2003 1:37 PM To: Harpreet; [EMAIL PROTECTED] Subject: RE: [PHP-WIN] Date question > From: Harpreet [mailto:[EMAIL PROTECTED] > > I am using php with sql server. I have a field expiration which is of type > datetime. > > I add a date for the expi

RE: [PHP-WIN] Date question

2003-06-24 Thread Darvin Andrioli
> From: Harpreet [mailto:[EMAIL PROTECTED] > > I am using php with sql server. I have a field expiration which is of type > datetime. > > I add a date for the expiration as '06/24/03 09:09:09' using a web form. > When i try to display the same expiration in an edit form using > $row["expiration"]

[PHP-WIN] Date question

2003-06-24 Thread Harpreet
I am using php with sql server. I have a field expiration which is of type datetime. I add a date for the expiration as '06/24/03 09:09:09' using a web form. When i try to display the same expiration in an edit form using $row["expiration"] it displays it as 'Jun 24 2003 09:09 AM'. How can I disp