datetime format in sql server

Question

Store Datetime in sql Server

 

 

02/12/2014  09:30 Pm---dd/mm/yyyy hh:mm tt

 

 

 and get this date from Sql server to label in asp

 

i want query for both insert and select

 

 

thank u

advance wish u happy new year