Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Using DBI::Sybase having problem with Date format

by mpeppler (Vicar)
on May 11, 2007 at 06:20 UTC ( #614820=note: print w/replies, xml ) Need Help??


in reply to Using DBI::Sybase having problem with Date format

DBD::Sybase also supports the following:
$dbh->syb_date_fmt('MDY1_YYYY');
for this functionality. This works with the Sybase libraries, and I assume that this also works with FreeTDS.

Michael

Replies are listed 'Best First'.
Re^2: Using DBI::Sybase having problem with Date format
by derby (Abbot) on May 11, 2007 at 15:07 UTC

    mpeppler ... syb_date_fmt works great with the Sybase libs but for freetds, it appears to be a no-op (and that's the latest version of freetds, the version ubuntu packages does not even have that method).

    -derby
      Thanks for the update. I guess that this isn't one of the "important" functions that have priority to get implemented in FreeTDS...

      Michael

      Your right I could not get this to work. Your convert reply works a dream derby thanks again your a total star!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://614820]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (7)
As of 2020-12-01 12:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How often do you use taint mode?





    Results (5 votes). Check out past polls.

    Notices?