Posted by othellomy on 11/23/06 07:17

You can try something like:

select *
from sometable
where convert(datetime, '20060101 ' + J_TIM) <
convert(datetime,'20060101 ' + substring(F_TIM,1,2) + ':' +
substring(F_TIM,3,2))

paul_zaoldyeck wrote:
> i have another problem.and it's now on converting a char(4) to datetime
> here is the situation
> J_TIM < F_TIM
>
> J_TIM is datetime while F_TIM is char of 4
>
> example
>
> J_TIM = 20:30
> F_TIM = 2030
>
> how can i convert F_TIM to datetime so that i can compare them.
> ???
>
> thanks

• Next in forum: Re: Help with a complex UPDATE query
• Prev in forum: CONVERSION FROM CHAR(4) TO DATETIME
• Thread view: Re: CONVERSION FROM CHAR(4) TO DATETIME

[Reply to this message]