On Tue, 2006-06-06 at 23:10 +0200, Graeme Geldenhuys wrote:
> Or do what we did at our company after fighting for ages with
> different RDMS handling dates differently, not to mention 3rd party
> tools accessing the databases as well. We standardized on the
> International ISO 8601 date time format and use a string field to
> store the value.
> http://www.cl.cam.ac.uk/~mgk25/iso-time.html
>
> For storage we use: yyyymmddThhmmss eg: 20060606T230300
> For display we use: yyyy-mm-dd hh:mm:ss eg: 2006-06-06 23:03:00
>
> A empty date or time is simply stored using zeros.
> We even wrote a few routines doing the different conversions from
> TDateTime to String or other way round (with lots of unit tests of
> course!)
>
> My 2 cents worth... :-)
>
> Regards,
> Graeme.
Yes, we did conceptually the same thing on our HP3000's since the
database (IMAGE) doesn't have any date or time datatypes.
Dave.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
