[CLUE-Tech] databases and timestamps ... 'since' idiom

[Dave Price]

The real issues are:

Getting text format dates (in various styles) into a format that can be 
compared.
Getting now() into a compatible format
Allowing for the entry (preferably as a command line arg) of the beginning 
date of the comparison range.

right now i am fumbling about with my own 'date numbers' ... since i care 
not about the time portion, i am using 20010318 to represent Mar 18, 2001 
... hey at least it is y-2k compliant.  It is getting a little old trying 
to right subroutines in perl to parse out every new way that a date gets 
printed in a text-file report though.

BTW: greater than does not even come close ... at the very least the 
comparison needs to be 'between' i.e.:  then() <= n <= now()

(but thanks for the advise)
At 03:48 PM 03/17/2001 -0700, you wrote:
>How about just ">" (greater than)
>
>----- Original Message -----
>From: "Dave Price" <davep at support-one.com>
>To: <clue-tech at clue.denver.co.us>
>Sent: Saturday, March 17, 2001 1:06 PM
>Subject: [CLUE-Tech] databases and timestamps ... 'since' idiom
>
>
> > could someone here please point me in the direction of a simple way to
> > implement a 'since'
> > syntax, either in bash or sql (or other) ...
> >
> > what i have in mind is a comparison of timestamps contained in both
> > flat-file and postgres table to see if they are 'since' a given time ...
> > i.e. between 'then' and 'now()'
> >
> > is there a nice shorthand or 'idiom' for this expression?
> >
> > aloha,
> >
> > dave price - davep at support-one.com - 303-378-9053
> >
> > _______________________________________________
> > CLUE-Tech mailing list
> > CLUE-Tech at clue.denver.co.us
> > http://clue.denver.co.us/mailman/listinfo/clue-tech
> >
> >
>
>_______________________________________________
>CLUE-Tech mailing list
>CLUE-Tech at clue.denver.co.us
>http://clue.denver.co.us/mailman/listinfo/clue-tech