An odd date from sql - what is it?

[josephinetedesc]

1801-01-01 00:00:00.000

Hi all when I do a query in SQL I get a date that looks like the date above.

Can anone tell me what it is?  Is it a hex code for null or something???  Qlikview gives me the same thing.

Jo

[josephinetedesc]

timestamp(0)

timestamp(-36161)

This is apparently the Clarion number and Crystal seems to use the Clarion number.  So Excel uses 1/1/1900 as day1, but Crystal/Clarion seems to use this other number as their day1 +4 to get the 1/1/1801 .

Thank you all again.

Jo