SQL datetime format to date only

Question

I am trying to select the DeliveryDate from sql database as just date  In the database  i am saving it as datetime format  How is it possible to get just date    SELECT Subject  DeliveryDate  from Email Administration  where MerchantId    MerchantID   03 06 2011 12 00 00 Am just be selected as 03 06 2011    Thanks  alot in advance

User · Answer

try the following as there will be no varchar conversion  SELECT Subject  CAST DeliveryDate AS DATE  from Email Administration  where MerchantId    MerchantID

User · Answer

SELECT Subject  CONVERT varchar 10  DeliveryDate  as DeliveryDate from Email Administration  where MerchantId    MerchantID

User · Answer

if you are using SQL Server use convert  e g  select convert varchar 10   DeliveryDate  103  as ShortDate  more information here  http   msdn microsoft com en-us library aa226054 v sql 80  aspx

User · Answer

After perusing your previous questions I eventually determined you are probably on SQL Server 2005  For US format you would use style 101  select Subject          CONVERT varchar DeliveryDate 101  as DeliveryDate from Email Administration  where MerchantId   MerchantID

User · Answer

With SQL server you can use this   SELECT CONVERT VARCHAR 10   GETDATE    101  AS  MM DD YYYY     with mysql server you can do the following  SELECT   FROM my table WHERE YEAR date field     2006  AND MONTH date field     9  AND DAY date field     11

[sql] SQL datetime format to date only

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2005

Examples related to datetime