Null date storage
Johnson, Harold A EDUC:EX
Harold.A.Johnson@gems1.gov.bc.ca
Thu, 11 Sep 2003 08:53:27 -0700
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C3787C.4DA6A7D2
Content-Type: text/plain;
charset="iso-8859-1"
Just to refresh my memory, but which product is the one responsible for
storing null dates as 17-Nov-1858 in RDB? Is it RDB itself or Powerhouse?
External queries (depending on the product) either show a blank, a null or
the 17-Nov-1858 date. What's normally done here? Can this date be
modified somehow to show a real null ?
thnx
------_=_NextPart_001_01C3787C.4DA6A7D2
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Wild Card/Generic retrieval</TITLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=698504715-11092003><FONT face=Arial color=#0000ff size=2>Just
to refresh my memory, but which product is the one responsible for storing null
dates as 17-Nov-1858 in RDB? Is it RDB itself or Powerhouse?
External queries (depending on the product) either show a blank, a null or the
17-Nov-1858 date. What's normally done here? Can this
date be modified somehow to show a real null ?</FONT></SPAN></DIV>
<DIV><SPAN class=698504715-11092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=698504715-11092003><FONT face=Arial color=#0000ff
size=2>thnx</FONT></SPAN></DIV>
<DIV><SPAN class=698504715-11092003></SPAN> </DIV>
<DIV><FONT size=2></FONT> </DIV></BODY></HTML>
------_=_NextPart_001_01C3787C.4DA6A7D2--