date conversion

valen53

i use sql2000, so the date format i query are apr, 1 2003, 12:00
but i want split it to 04/01/2003 ...
but i can't change the date format from apr to 04..

below is my code.. anyone can help me ??
thank u

list ($mon,$day,$year, $time) = split (' ', $Itemrow[StartDate]) ;
$repairDate = date('m/d/Y', mktime(0,0,0, "$mon,$day,$year"));

planetsim

You can actually do it like this

date("format here","time being formatted")

valen53

Originally posted by planetsim
You can actually do it like this

date("format here","time being formatted")

actually the problem is i split the date.. month is apr - string,
but i want to convert to 04 , int.. mktime () is int , tht y i can't mktime()

so any method can the date from apr, 03 2003 to 04/03/2003 ??

thank ur reply

Weedpacket

It would probably be smarter to do the date conversion in SQL Server, not PHP. That way, if and when you migrate to another database that returns datetimes in a different format, you'd only need to alter the query, not how its results are parsed (plus, it would probably be faster). SQL Server doesn't have a huge amount in the way of date/time functions, but it does have DAY(), MONTH() and YEAR(); CONVERT() could no doubt also be used.

Unfortunately strtotime() doesn't like the format given (it didn't like your example); but it does accept, eg. "April 1 2003 2:50 PM" .

phplearner

Does anyone have a solution for this? I also need the 04/03/2003 format and am surprised that PHP doesn't have a built-in function for this.

Weedpacket

I'll just shut up then, shall I?

phplearner

Originally posted by Weedpacket
I'll just shut up then, shall I?

Huh?

Maybe I misread your:

"April 1 2003 2:50 PM" .

Am I still missing exactly HOW to get: 04/01/2003 (preferably 4/1/03) to display FROM 2003-04-01 in the database, and HOW to take a 4/1/03 form input field and write 2003-04-01 TO the database?

If there's an internal MySQL Conversion trick I'd sure like to know it!!!

Thanks.

Weedpacket

MySQL has plenty of date and time functions that can be used to convert MySQL-format dates into other formats (including Unix timestamps which are often best for PHP); certainly more than has SQL Server 2000, which is what the original post was in relation to.

Aside from that you might want to look at the [man]strtotime[/man] function along with [man]date[/man] and see if using the two together is suitable for you.

phplearner

Thanks for all the good references.

FYI, I found this scrolling down the added user comments section on one of the MySQL or PHP pages you referred me to:

alexfpoole at yahoo.co.uk
26-Mar-2002 12:09

Note that this function WILL NOT parse US date format with dashes (m-d-Y) but it WILL

parse it with slashes (m/d/Y), so use these functions to move between SQL and US date

formats:

function usDate2sql($usdate){//m-d-Y --> Y-m-d
$usdate=str_replace("-", "/", $usdate);
return date("Y-m-d", strtotime($usdate));
}

function sqlDate2us($sqldate){//Y-m-d --> m-d-Y
return date("m-d-Y", strtotime($sqldate));
}

According to the MySQL doc:

%m = Month
%e = Day
%y= Year (00)
%Y= Year(0000)

So I could change the 'Y' in the function to a 'y' and end up with '4/1/03' so it would appear.

Functions are new to me, so need to figure out the exact mechanics (it would be more helpful if everyone //'d their code in more detail for us 'Newbies' 🆒