obarahmeh (9/24/2008)
Dear All,When you run the following command:
SELECT GETDATE() AS [CurrentDateTime]
The Result is : 2008-09-24 12:47:11.587
The question is: How can I get the following result from the above query:
20080924
Where do you want to show/use formatted dates?
If it is only for display
SELECT convert(varchar(8),getdate(),112)
Failing to plan is Planning to fail