 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Martin Crowley
Guest
|
 Posted: Tue Aug 26, 2003 12:11 pm Post subject: Preventing date format being changed to dd/mm/yy |
 |
|
Hello,
I'm using Borland Builder Ver 5, MySQL Version 4.0.12 with myodbc3.dll.
When I issue the query 'select curdate()' from a query object in Borland and
display it in a edit box, it gets displayed in
UK format. I actually want to retain the US "2003-08-31" format.
If I issue this select statement directly in SQL I get the US format.
I wondered if this was to do with BDE format settings (ie. there is a date
format option). I tried changing this but it didn't make any difference?
Can anyone help please?
Thanks,
Martin.
|
|
| Back to top |
|
 |
Martin Crowley
Guest
|
| Posted: Wed Aug 27, 2003 12:22 am Post subject: Re: Preventing date format being changed to dd/mm/yy |
|
|
Resent, as it appeared to vanish from the group.
"Martin Crowley" <martin (AT) 2oriel (DOT) freeserve.co.uk> wrote
| Quote: | Hello,
I'm using Borland Builder Ver 5, MySQL Version 4.0.12 with myodbc3.dll.
When I issue the query 'select curdate()' from a query object in Borland
and
display it in a edit box, it gets displayed in
UK format. I actually want to retain the US "2003-08-31" format.
If I issue this select statement directly in SQL I get the US format.
I wondered if this was to do with BDE format settings (ie. there is a date
format option). I tried changing this but it didn't make any difference?
Can anyone help please?
Thanks,
Martin.
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
