home page
about us
consulting service
maintenance plan
training
faqs
hints and tips
resources
how to
testimonials
news
blog
case studies
clients
register
log in
contact us
SELECT [Tablename.DateTimeField], CONVERT(Varchar(10),CONVERT(Date,[Tablename.DateTimeField]),103) as [Shipped Date],CONVERT(Varchar(8),CONVERT(Time,[Tablename.DateTimeField])) as [Shipped Time] FROM Tablename