Julian Date Coversion

I am using SQL server 2000 with data from as/400 dts transfer. I have a date field with julian dates that look like this:

101087

Any idea how to convert this date to regular date in display in frontpage created databse wizard results. I have tried to tweek SQL drive in odbc admin. no luck as of yet.
timokeeffeAsked:
Who is Participating?
 
hhammashCommented:
0
 
seanpowellCommented:
You have it set as a Date data type and not a Char data type in SQL, correct?
0
 
timokeeffeAuthor Commented:
There is onyl one date type option to change it to in sql and that is smalldatetime. it fails to do this change when I go to save the change made in table design.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.