Julian date conversion to yyyy-mm-dd : hh-mm-ss

via · Post by **via** » Wed Oct 12, 2005 1:26 pm

Hi dsx and vidya,
I tryed chaning the ouput data type to datetime , but there is a conflict with the string to datetime datatype. Now i am thinking of pushing this entire date+time as varchar to sqlserver and then write a stored procedure to chage it to datetime!
This is some thing that is not suggestable, any other tip is welcome,
Thanks
Via

ameyvaidya · Post by **ameyvaidya** » Wed Oct 12, 2005 2:02 pm

As from what I read from searches in the same forum (Try "SQL Server datetime" with the all words match option), If you get the format right, SQl server will parse the varchar and convert it to the right datetime format. No need of a Stored Procedure.

This issue has been taken care of many times (29 as per search results).

Also if it can not be solved using the existing topics, I'd recommend adding error messages and more info about this new issue. Coz right now there is insufficient data for this new issue to make any tips/recommendations.

via · Post by **via** » Wed Oct 12, 2005 2:29 pm

Hi,
I finally did forced the data type to timestamp tough it is a datetime in sql, it worked:)
Thanks folks for all your help, i really appreciate your responce.

Via

ray.wurlod · Post by **ray.wurlod** » Wed Oct 12, 2005 2:56 pm

Would you care to share the actual expressions you used, to save someone else this research task when they search the Forum?

via · Post by **via** » Thu Oct 13, 2005 7:11 am

Sure Ray,
As i posted in my earlyer messages, i only changed the datestage datatype to timestamp, left the sql server datatype as datetime and the rest ramain same.
Regard,
Via