Jul 12, 2004 #1 jorg32 Programmer Jul 10, 2003 57 BE Hi, Can somebody tell me how I convert : 04/26/2004 (=nvarchar(50)) to 20040426 (char) Thanks for helping me! Jorg
Hi, Can somebody tell me how I convert : 04/26/2004 (=nvarchar(50)) to 20040426 (char) Thanks for helping me! Jorg
Jul 12, 2004 #2 VintageWine IS-IT--Management Sep 18, 2002 191 GB SELECT CONVERT(char(8),CONVERT(datetime,'04/26/2004'),112) Upvote 0 Downvote