Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Date formatting |
Tue, Feb 16 2010 8:29 PM | Permanent Link |
Bryn Lewis | I have a db setup on a PC with regional settings set to English (Australia). The date fields are:
dd/mm/yyyy When I do a select form elevateDB manager, the field is returned as 'yyyy-mm-dd' When I select from delphi and read the field as .asString I get 'dd/mm/yyyy' -This is what I want. I have deployed to a machine which had regional settings set to English (United States), dates as 'mm/dd/yyyy' I reset the setting to 'dd/mm/yyyy' on the machine, but when I select from delphi and read the field as .asString I am still getting 'mm/dd/yyyy' Are there further config settings for elevateDb or inmy components that I need to reset? |
Wed, Feb 17 2010 12:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bryn,
<< When I do a select form elevateDB manager, the field is returned as 'yyyy-mm-dd' >> The EDB Manager forces all date/time displays and edits to ANSI format, which is the SQL standard: http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=2&topic=34 << I reset the setting to 'dd/mm/yyyy' on the machine, but when I select from delphi and read the field as .asString I am still getting 'mm/dd/yyyy' Are there further config settings for elevateDb or inmy components that I need to reset? >> If you changed the regional settings on the actual machine, then your application should return the date/time strings in the regional settings format, provided that none of the TFields or data-aware controls being used are re-formatting the date/time strings into a specific format. Did you restart the application after changing the regional settings ? -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |