Re: date comparioson in a Case statement
From: Raymond D'Anjou \(raydan\) (raydan_at_canatrade.nospamcom)
Date: 04/05/04
- Next message: Prasad Koukuntla: "Re: date comparioson in a Case statement"
- Previous message: Vishal Parkar: "Re: Very Tricky SELECT statement"
- In reply to: ajmister: "date comparioson in a Case statement"
- Next in thread: ajmiester: "Re: date comparioson in a Case statement"
- Reply: ajmiester: "Re: date comparioson in a Case statement"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Apr 2004 16:00:50 -0400
Both "NA" and e_dt have to be the same datatype.
Try this:
> when ex.e_dt < a1.d_dt then "NA"
> else CONVERT(VARCHAR(10), e_dt, 111)
> end,
"ajmister" <ajmister@optonline.net> wrote in message
news:eTvHLk0GEHA.4012@TK2MSFTNGP09.phx.gbl...
> Hi
>
> I have a case statement where I am comparing two dates
>
> rpt_dt=
> case
> when ex.e_dt < a1.d_dt then "NA"
> else e_dt
> end,
>
> give me an error
> Syntax error during implicit conversion of VARCHAR value 'NA' to a
DATETIME
> field.
>
> rpt_dt=
> case
> when ex.e_dt < a1.d_dt then ""
> else e_dt
> end,
>
> runs successfully but I get Jan 1, 1900 values in he fields where ex.e_dt
<
> a1.d_dt .
>
> Not sure why it is extracting incorrect values.
> Ajay
>
>
- Next message: Prasad Koukuntla: "Re: date comparioson in a Case statement"
- Previous message: Vishal Parkar: "Re: Very Tricky SELECT statement"
- In reply to: ajmister: "date comparioson in a Case statement"
- Next in thread: ajmiester: "Re: date comparioson in a Case statement"
- Reply: ajmiester: "Re: date comparioson in a Case statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
