Echo Date from Recordset 1

[vivilady]

Hi, anyone have any idea why my date is being displayed as 1110288534 in my page. I checked the DB and the date looks fine there but when I echo it out it shows like this
1110288534

here is the echo code

while (!$Recordset1->EOF) {
$maindates = $Recordset1->Fields("maindate");

echo ".$maindates->value.";

$Recordset1->MoveNext();
}

The result on screen like said is: 1110288534 etc even though it has a right date displying in the DB itself.

Any suggestions?

 

[kenrbnsn]

No one will have any idea, unless you give us more information. How is the field defined in your database?

Ken

 

[vivilady]

it is defined as a general date in access db. and the column name is maindate

 

[vivilady]

does that answers the question you needed kenrbnsn? if not please tell me exactly how you want me to re-phrase the question.

Thanks for your help

 

[kenrbnsn]

I don't know access db, so I'm only guessing here.

Your DB display program, might be formatting the date field to be "nice", instead of showing you the raw information.

You can try:

echo date('Y-m-d',$maindates->value);

See the section in the PHP manual

http://www.php.net

on displaying dates.

Ken

 

[vivilady]

THANK YOU kenrbnsn !!! You are a genius! it works.
so you can consider yourself as a MYSQL and ACCESS DB guru amongst the other areas that you are already a guru in!

Thank you ever so much...