freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] [PATCH] Setting the default date time format in locales.conf

From: David Dick <ddick AT cpan.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: [freetds] [PATCH] Setting the default date time format in locales.conf
Date: Mon, 19 Apr 2010 08:01:49 +1000

According to the Transact-SQL User's Guide, the default display format for dates is “Apr 15 1987 10:23PM” [1]. Therefore, this patch will set this datetime format for all locales. Is this ok?

1. http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.blocks/html/blocks/blocks36.htm
Index: locales.conf
===================================================================
RCS file: /cvsroot/freetds/freetds/locales.conf,v
retrieving revision 1.7
diff -u -r1.7 locales.conf
--- locales.conf 9 Jun 2006 15:52:41 -0000 1.7
+++ locales.conf 18 Apr 2010 21:51:04 -0000
@@ -1,23 +1,23 @@
[default]
- date format = %b %e %Y %I:%M:%S:%z%p
+ date format = %b %e %Y %I:%M%p

[en_US]
- date format = %b %e %Y %I:%M:%S:%z%p
+ date format = %b %e %Y %I:%M%p
language = us_english
charset = iso_1

[es_ES]
- date format = %b %d %Y %I:%M%p
+ date format = %b %e %Y %I:%M%p
language = spanish
charset = iso_1

[pt_BR]
- date format = %d/%m/%Y %H:%M
+ date format = %b %e %Y %I:%M%p
language = Portuguese
charset = iso_1

[it_IT]
- date format = %d/%m/%Y %H:%M
+ date format = %b %e %Y %I:%M%p
language = Italiano
charset = iso_1

[freetds] [PATCH] Setting the default date time format in locales.conf, David Dick, 04/18/2010