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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Converting DATEFORMAT and HOURS from Sybase to SQL 2000
I have a script in which I need to convert into SQL 2000 syntax and need help with the Dateformat YYMMDD, HHMM, and Hours.... SELECT WRK_WO_NUMBER AS WO_Number, DATEFORMAT(WRK_ENTERED_DATE_TIME,'yyyy/mm/dd')AS Date_Entered... -
Converting Sybase To SQL Server Issue
I need help in converting this Sybase script to run in SQL Server. Some of the main issues are; DATEFORMAT(WRK_PROCESS_DATE,'YYYYMMDD') AS 'PROC_DATE', DATEFORMAT(WRK_COMPLETION_DATE_TIME,'YYYYMMDD') AS 'COMPL_DATE', (CHAR_LENGTH(WRK_COMPLETION_CODES)*5/3)-1)) AS 'CODE_STR', Can anyone...- amccoy33
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
