Hi all

How am i able to retrieve time and date individually from datetime format SQL 2005?
I'm using Visual Basic 2005 to retrieve it.

Thanks.

Well, can you be a bit more elaborative!!

Regards
Mike

A potential query would be:

SELECT Convert(Varchar(10), getdate(), 101) as DateNow, Convert(varchar(10), getdate(), 108) as TimeNow

which returns

DateNow TimeNow
09/11/2007 11:30:52

For all convert formats go here
http://msdn2.microsoft.com/en-us/library/ms187928.aspx

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========