Displaying date

[phenley]

Hi,

I retrieve from a date type column DateAdded in my database.

Its of the form YYYY-MM-DD. So when I display it on my HTML page using

$sqlfields="SELECT * FROM Customers WHERE \"CompanyName\" = '$CompanyName'";
$rsfields=odbc_exec($conn,$sqlfields);
while(odbc_fetch_row($rsfields)){
if($Field == 'DateAdded'){
$Field=odbc_result($rsfields,$Field);
$Field=date("d/m/Y", $Field);
}
else{
$Field=odbc_result($rsfields,$Field);
}
echo $Field;

[wilsonodk]

To use the date() function in php you need a unix timestamp. You'll need to convert it from the SQL timestamp, do that using strtotime.

$Field=date("d/m/Y", strtotime($Field));

I didn't look to see if the other parts of your code were correct, I've never used ODBC. So, my code assumes that $Field is actually returning a SQL date in the string format of YYYYMMDD.

[phenley]

wilsonodk ur a saint

that one function strtotime i'd never have gotten.

now the dates appear as 23/01/2004 as i wanted them to instead of 2004/01/23

Many Thanks & a Merry Christmas