Skip to Content.
Sympa Menu

freetds - Re: [freetds] SOT: DBI::ODBC datetime format for update

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Roderick A. Anderson" <raanders AT tsmg.us>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SOT: DBI::ODBC datetime format for update
  • Date: Wed, 15 Sep 2004 11:38:59 -0700

This arrived about 5 minutes after I discovered this (see my other
message) and therefore making a complete fool of myself! But you
confirm my findings.


Thanks,
Rod
--
Roderick A. Anderson
Technology Services Management Group
<http://www.technologyservicesmanagementgroup.com/>
Spokane WA, 99202



Frediano Ziglio wrote:
> Il mer, 2004-09-15 alle 20:03, Roderick A. Anderson ha scritto:
>
>>Sorry for the off topic post but my web searches have not produced an
>>answer. In fact I'm not necessarily looking for an answer but a pointer
>>(or a whack from a clue-stick) to where to look or the correct terms to
>>use for my search. I have tried all the obvious terms in various
>>collections and combinations and only found information on how to change
>>the output of datetime fields.
>>
>>I'm getting a failure message using DBI::ODBC on a Win2k server
>>accessing a SQL Server database (different system) via a system dsn. I
>>can't figure out what format to use for a datetime field. I've not had
>>a problem doing similar operation using Win32::ODBC with a smalldatetime
>>field. But when using DBI::ODBC and updating a datatime field I get
>>errors like this:
>>
>>DBI Error:DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server
>>Driver] Invalid character value for cast specification (SQL-22018)(DBD:
>>st_execute/SQLExecute err=-1) at script.pl line 77.
>>
>>The variable used is set to '09/15/04' but even attempts using '20040915
>>05:05:05' and variations fail.
>>
>>This goes away when I remove the code to update the datetime field.
>>
>>So where should I go or what should I search for?
>>
>
>
> Try ISO format like '2004-09-15 05:05:05'. There is also an ODBC syntax
> {ts 2004-09-15 05:05:05} that should be supported by all ODBC drivers.
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> ---
> [This E-mail scanned for viruses by Declude Virus]
>
---
[This E-mail scanned for viruses by Declude Virus]





Archive powered by MHonArc 2.6.24.

Top of Page