CNC Pro
Active Member
Good day folks,
I'm currently in the process of coverting some data from the our AS400 onto MSSQL DB ( SQL2000). The problem I'm having is converting Julian dates on MSSQL. Can anybody help be with a script that can be run on MSSQL that will convert the julian date to conventional date ( MM/DD/YYYY)?
Your help with in this regard will truly be appreciated.
JL
I'm currently in the process of coverting some data from the our AS400 onto MSSQL DB ( SQL2000). The problem I'm having is converting Julian dates on MSSQL. Can anybody help be with a script that can be run on MSSQL that will convert the julian date to conventional date ( MM/DD/YYYY)?
Your help with in this regard will truly be appreciated.
JL