Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ashorey
-
JD Edwards Date Conversion
I use this to convert JDE Julian dates, DECLARE @TEST AS VARCHAR(6) SELECT @TEST='102312' SELECT DATEADD(DAY, CAST(SUBSTRING(@TEST, (LEN(@TEST)-2) ,3) AS INT)-1, CAST((CAST(CAST(ISNULL(SUBSTRING(@TEST, (LEN(@TEST)-5) ,1),0) AS INT) + 19 AS VARCHAR(4))+ SUBSTRING(@TEST, (LEN(@TEST)-4)...- ashorey
- Post #2
- Forum: Microsoft SQL Server: Programming
