Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: DateTime Values
Date: Nov 18 1997 7:39PM
> Thanks for replying, Michael.
> But the default datetime format is different on some locations. While
> snooping around in my company, i found several output formats for the
> datetime-type. To change this behavior, a call to cs_dt_info(cs_set,
> cs_dt_convfmt) has to be made. I hacked this into my version of
> CTlib.xs, but i think this function is important enough to get into
> sybperl 2.09 (like cs_locale).
A patch would be welcome :-)
> Von: Michael Peppler
> An: SYBPERL-L@trln.lib.unc.edu
> Betreff: Re: DateTime Values
> Datum: Donnerstag, 13. November 1997 16:50
> Bernd.Brinkmann@Bertelsmann.DE wrote:
> > As I am quiet new with Sybperl, I have encounterd a problem -
> > Can anyone give me a clue, if there is a possibility to retrieve a
> > DateTime value (date and time) without using "UseDateTime" followed by
> > $date->crack.
> > I need this for a fast (!!!) output-routine that dumps large amounts
> > data (> 1.500.000 rows gathered by joins, etc.) and therefore a
> > conversion inside a while-loop is too time consumpting.
> How do you need your data converted?
> You could write your queries to return the date and the time
> portion separately (using convert()), or you could use some
> fancy split() or pattern match to extract the appropriate fields.
> The default datetime format is
> Nov 13 1997 7:47:05:293AM
> which could be matched by something like
> $date =~ /(\w+) +(\d+) +(\d+) +(\d+):(\d+):(\d+):(\d+)(\w+)/;
> $mon = $1;
> $day = $2;
> $year = $3;
> Michael Peppler -||- Data Migrations Inc.
> firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
Michael Peppler -||- Data Migrations Inc.
email@example.com -||- http://www.mbay.net/~mpeppler