Skip to Content.
Sympa Menu

freetds - Re: datetime format

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bradley Bell <bradleyb AT u.washington.edu>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: datetime format
  • Date: Wed, 19 Dec 2001 14:31:47 -0800


Of course, that doesn't allow for milliseconds...
-brad

On Wed, Dec 19, 2001 at 11:29:05AM +1200, Franck Martin wrote:
> I think freetds should output the date in the ISO format which I think is
> something like '20010121 15:45:22', Then after it is up to the application
> to convert it to the display format. I think all conversion function work
> from ISO date to any date format.
>
>
> Franck Martin
> Network and Database Development Officer
> SOPAC South Pacific Applied Geoscience Commission
> Fiji
> E-mail: franck AT sopac.org <mailto:franck AT sopac.org>
> Web site: http://www.sopac.org/
> <http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/
> <http://fmaps.sourceforge.net/>
>
> This e-mail is intended for its addresses only. Do not forward this e-mail
> without approval. The views expressed in this e-mail may not be necessarily
> the views of SOPAC.
>
>
>
> -----Original Message-----
> From: James K. Lowden [mailto:jklowden AT speakeasy.org]
> Sent: Tuesday, 18 December 2001 7:10
> To: TDS Development Group
> Subject: [freetds] Re: datetime format
>
>
> Hi Bradley,
>
> Bradley Bell wrote:
> > isql uses db-lib, so maybe this is a limitation of db-lib?
>
> What you're seeing in isql is db-lib's default conversion, the result (I
> assume) of calling dbbind to make a string of a datetime field. A
> db-lib application can call dbdatecrack() and construct any string it
> likes (or rely on server-side conversions, of course).
>
> You might be candidate #2 for Eric Deutsch's suggestion (Fri, 7 Dec 2001
> 16:22:30 -0800 (PST)) that freetds.conf allow a configurable default
> datetime-to-varchar conversion.
>
> Eric Deutsch wrote:
> > It would be sensational if one could specify in freetds.conf one's own
> > strftime format string. I like all my dates to show up as
> > '2001-12-07 15:45:22' without having to CAST and CONVERT and stuff. I do
> > this by manually going into the FreeTDS driver and replacing the default
> > format string with the one that produces this.
>
> For the time being, you might want to apply his patch. I'd be tempted
> instead to interpose views or stored procedures between the tables and
> the application to deal with vendor-specific behavior.
>
> ---
> You are currently subscribed to freetds as: [bradleyb AT u.washington.edu]
> To unsubscribe, forward this message to $subst('Email.Unsub')

--
Bradley Bell
Computer Support Analyst
University of Washington
Classroom Support Services




Archive powered by MHonArc 2.6.24.

Top of Page