On Thu, 27 Oct 2005 14:46:02 -0700, Stan wrote:

>I have a table that has the significant date set up as a CHAR datatype with
>length of 8, i.e 20051027. I want to select all transactions where this date
>equals the system date.

"Hugo Kornelis" wrote:

> On Thu, 27 Oct 2005 14:46:02 -0700, Stan wrote:
>
> >I have a table that has the significant date set up as a CHAR datatype with
> >length of 8, i.e 20051027. I want to select all transactions where this date
> >equals the system date.
>
> Hi Stan,
>
> SELECT ....
> FROM ....
> WHERE YourDateColumn = CONVERT(char(8), CURRENT_TIMESTAMP, 112)
>
> But why are you storing a date as a CHAR column, instead of using the
> datetime datatype?
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)