PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Luc Van der Veurst <lucv at az dot vub dot ac dot be>
Subject: Re: Getting the raw value of a datetime field
Date: Dec 22 2005 6:03AM

Hi Alan,

And what if you convert the datetime field to a varchar including the
miliseconds ?

select convert(varchar(30), fieldname, 109)

Luc.

On Wed, 21 Dec 2005 17:41:39 -0800, "Alan Olsen"  wrote:

>Is there a way to get the "raw" value of a datetime field in Sybperl?  I
>have a datetime field that has millisecond values in is, but the display
>is munged to display only down to the minute.
>
>Ideas?
>