Posted by smileydip on 10/02/28 11:46

Hi Guys, Could some help me....
I am trying to use the below specified two field from "SysJobHistory"
table from "MSDB". Field name "run_date" and "run_time". Both this
fields are of INT data type. Data saved in the above two fields is in
this this format 20060501 and 204001 respectively. I want save the data
from this two field in another table in date time format. I want to
write a SELECT statement which converts the data from this two fields
into date time format so that it could be saved in another table which
has date time data type column respectively.

Regards

Dipesh Shah

• Next in forum: Re: Converting Int value to datetime
• Prev in forum: Syntax Help!
• Thread view: Converting Int value to datetime

[Reply to this message]