RE: Select/Omit logical on timestamp field

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

Dan,

Thanks, the second level text pointed me in the right direction.  I hadn't
provided any key fields, once I did that the select compiled fine.

Scott Mildenberger

> -----Original Message-----
> From: Dan Bale [mailto:dbale@samsa.com]
> Sent: Tuesday, February 19, 2002 11:51 AM
> To: midrange-l@midrange.com
> Subject: RE: Select/Omit logical on timestamp field
>
>
> Well, it looks like you've got it right.  From the DDS reference:
>
> If you are defining a timestamp field, you must specify the
> default value in
> the following format:
>          COMP(EQ 'YYYY-MM-DD-HH.MM.SS.UUUUUU')
>
> What does the second-level text for that error message say?
>
> - Dan Bale