Re: [PHP] Re: Date Question [SOLVED]

2006-03-17 Thread Tom Chubb
Thanks guys. On 17/03/06, João Cândido de Souza Neto <[EMAIL PROTECTED]> wrote: > > select date_format(date,"%d/%m/%y") as date from table > > It'll show in 17/03/06 format > > select date_format(date,"%d/%m/%Y") as date from table > > It'll show in 17/03/2006 format > > > Tom Chubb wrote: > > > P

[PHP] Re: Date Question

2006-03-17 Thread João Cândido de Souza Neto
select date_format(date,"%d/%m/%y") as date from table It'll show in 17/03/06 format select date_format(date,"%d/%m/%Y") as date from table It'll show in 17/03/2006 format Tom Chubb wrote: > Please can you help me. I've created a page where problems are posted into > a database and I am using

[PHP] Re: Date question

2006-02-24 Thread William Stokes
Yep. Nevermind... (and back to sleep) ""William Stokes"" <[EMAIL PROTECTED]> kirjoitti viestissä:[EMAIL PROTECTED] > Hello, > > I have a datetime column in MySQL DB. How can I match to that column from > php code if I only have the date information available. > > 2006-02-24 12:00:00 against

Re: [PHP] Re: Date Question.

2003-03-05 Thread Sebastian
OTECTED]> Sent: Wednesday, March 05, 2003 2:38 PM Subject: Re: [PHP] Re: Date Question. | He's recommending something like this.. | | $tmp = explode(' ', $date); | if (date("Y-m-d") == $tmp[0]) // date format -mm-dd | { | echo "Today"; | } |

Re: [PHP] Re: Date Question.

2003-03-05 Thread Kevin Stone
manual/en/function.explode.php http://www.php.net/manual/en/function.date.php - Kevin - Original Message - From: "Sebastian" <[EMAIL PROTECTED]> To: "Philip Hallstrom" <[EMAIL PROTECTED]> Cc: "php list" <[EMAIL PROTECTED]> Sent: Wednesday, March

Re: [PHP] Re: Date Question.

2003-03-05 Thread Sebastian
can you give an example? I am stil learning :) - Original Message - From: "Philip Hallstrom" <[EMAIL PROTECTED]> | Strip off the H:i:s part using explode() and use date() to get an | equivalent string for right now and if they match, today's the day. | | On Wed, 5 Mar 2003, Sebastian wro

[PHP] Re: Date Question.

2003-03-05 Thread Philip Hallstrom
Strip off the H:i:s part using explode() and use date() to get an equivalent string for right now and if they match, today's the day. On Wed, 5 Mar 2003, Sebastian wrote: > I have a date field in mysql in this format: Y-m-d H:i:s > > I would like to echo "Today" if the date is today, can someone

Re: [PHP] Re: date question

2002-09-29 Thread Matt
> From: "Jonas Geiregat" <[EMAIL PROTECTED]> > Sent: Sunday, September 29, 2002 10:56 AM > Subject: [PHP] Re: date question > and If I want to calculate from given date the next month > like strtotime("next month") gives me the date of one month in ad

[PHP] Re: date question

2002-09-29 Thread Jonas Geiregat
and If I want to calculate from given date the next month like strtotime("next month") gives me the date of one month in advanced from NOW but I want to get the date one month in advanced from a given date not NOW Jonas Geiregat wrote: > I have a date ex 24/08/02 > and I need to see if that date

[PHP] Re: date question

2002-09-29 Thread Jean-Christian Imbeault
Jonas Geiregat wrote: > > I have a date ex 24/08/02 > and I need to see if that date is the same date as it is today (only one > month later) but 5day's in advanced => that would be 24/09/02 > so if(date == date now - 5) > {true} > else{false} > > how can I do this right ? L

[PHP] Re: date question

2002-09-09 Thread yasin inat
oradaki bir gun kavramini biraz daha açarsan yardim edebilirim - umarim - timestamp mi yoksa baska -daha özel bir- formatta mi ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: date question

2002-09-09 Thread Erwin
Meltem Demirkus wrote: > Hi, > > Is there any function which returns the day , month or year of a > date ? You need two functions actually ;-)) use the date() function to generate the day, month or year from a timestamp use the strtotime() function to generate a timestamp from a date For examp

[PHP] Re: Date Question: finding 1st Monday of sept.

2002-02-22 Thread Jeff Bearer
Nevermind, I figured it out, didn't see that you could pass a timestamp to strtotime. Thanks. On Fri, 2002-02-22 at 14:22, Jeff Bearer wrote: > Hello, > > I'm trying to find out how to calculate some dates, and the part I'm > having problems with is finding the date of the first Monday in > Sep