.NET / ASP.NET / SQL Server / Developer Express
-- Get current date (without time) as string:SELECT CONVERT( CHAR(8), GetDate(), 112)
-- Get current date (without time) as date:SELECT CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME)
No comments:
Post a Comment