Re: dates B.C.

Posted in 1996

Sally Woolrich — Wed, 13 Mar 96 18:25:00 GMT — source: Informix-list mailing list archive (1991-1998)

In article <4hv3t1$o2r@accursio.comune.bologna.it> ret2519@iperbole.bologna.it "Giorgio Bignozzi" writes: > How can I use a date value to store a date Before Christ ? > Please don't suggest to use a flag ! I havn't tried this myself but as Informix stores dates as some kind of integer value I would suspect this is NOT a problem so long as your DBDATE is set to 'DMY4' (I'm in the UK!) not 'DMY2'. I would test this with a basic PERFORM screen. 31/Dec/1899 (or is it 01/Jan/1900?) are stored as zero. Dates before this are stored as negative numbers, dates after as positive ones - hence the ability do do arithmetic on dates. Hope this helps! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================