Closed Thread Icon

Topic awaiting preservation: PHP, DSN Less Connection AN Access Database AND trouble with 'Date' (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=23265" title="Pages that link to Topic awaiting preservation: PHP, DSN Less Connection AN Access Database AND trouble with &amp;#039;Date&amp;#039; (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: PHP, DSN Less Connection AN Access Database AND trouble with &#039;Date&#039; <span class="small">(Page 1 of 1)</span>\

 
paritycheck
Bipolar (III) Inmate

From:
Insane since: Mar 2004

posted posted 09-11-2004 10:58

I'm connecting to an access database using PhP without making any DSN (DSN less connection) but I have a problme when I try to display a field value which is of date time format in the access database. When I invoke the .. $Variable->value to be displayed I get a string of weird numbers intead of a date. The other text based fields are being outputted fine but I've having problmes with the date fields.

ANy help guys

Skaarjj
Maniac (V) Mad Scientist

From: :morF
Insane since: May 2000

posted posted 09-11-2004 11:52

slow down a sec sonny....take it slowly, one step at a time. First, do you mean DNS, not DSN?

Second, what method are you using to pull the data up out of the tables?

Third, have you tried running the data through the unserialise() function?

DL-44
Maniac (V) Inmate

From: under the bed
Insane since: Feb 2000

posted posted 09-11-2004 15:58
quote:
I get a string of weird numbers intead of a date



Are you certain that this "string of wierd numbers" is not simply the unformatted date? Dates are not stored in a traditional date format, and you will need to format the date when you pull it out of the database.

paritycheck
Bipolar (III) Inmate

From:
Insane since: Mar 2004

posted posted 09-12-2004 09:12

sorry for being to hyper just got a lot opn my ming
I never did think of reformatting the incoming string as adate :S gee whiz I really need some time out.

I'll try it and check thats for the info

« BackwardsOnwards »

Show Forum Drop Down Menu