Home » RDBMS Server » Server Administration » Date Format wrong
Date Format wrong [message #370163] Tue, 26 December 2000 21:35 Go to next message
Kiki
Messages: 13
Registered: November 2000
Junior Member
Hi there,
I Have a problem of converting the date format.
one of my fields that I am working with are date with format DD-MM-YY. however, somehow that date is converted to string. my question is when I converted back to date with format YYYY. it ll return 2096 for 96. Is there any way which I can convert that 96 to 1996?

Report message to a moderator

Re: Date Format wrong [message #370166 is a reply to message #370163] Tue, 26 December 2000 22:53 Go to previous message
P. Lavanya
Messages: 8
Registered: November 2000
Junior Member
Hi,
Try 'DD-MM-RRRR' date format.

Bye,
lavP

Report message to a moderator

Previous Topic: Please help us ....
Next Topic: Dynamic SQL error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 06:33:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.