SQL Date Format

This query will return date and time required fields.

 SELECT ENTRY_DATE ,

  CONVERT(varchar,ENTRY_DATE,100) DateTime,

  CONVERT(varchar,ENTRY_DATE,10) Date ,

  CONVERT(varchar,ENTRY_DATE,108) Time ,

  substring(CONVERT(varchar,ENTRY_DATE,106),1,2) Day,

  substring(CONVERT(varchar,ENTRY_DATE,106),4,3) CMonth,

  substring(CONVERT(varchar,ENTRY_DATE,105),4,2) NMonth,

  substring(CONVERT(varchar,ENTRY_DATE,106),8,4) Year,

  left(right(CONVERT(varchar,ENTRY_DATE,100),7),2) Hours_12,

  substring(CONVERT(varchar,ENTRY_DATE,108),1,2) Hours_24,

  substring(CONVERT(varchar,ENTRY_DATE,108),4,2) Minutes,

  substring(CONVERT(varchar,ENTRY_DATE,108),7,2) Second,

  right(CONVERT(varchar,ENTRY_DATE,100),2) AM_PM from DCR_AUTO_INSERT_LOG