Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Server Time

Author  Topic 

sunny_10
Yak Posting Veteran

72 Posts

Posted - 2014-03-16 : 12:36:08
Hi

I want to display Server Time using stored procedure in Visual Basic 6

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-03-16 : 12:55:20
SELECT GETDATE()

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

sunny_10
Yak Posting Veteran

72 Posts

Posted - 2014-03-16 : 13:10:06
hi

it includes date i want only time

Thanks
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-03-17 : 02:46:11
Use "time" , what sql server version are you using?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

VeeranjaneyuluAnnapureddy
Posting Yak Master

169 Posts

Posted - 2014-03-17 : 04:29:47
select CONVERT(varchar(10),getdate(),108)

Veera
Go to Top of Page
   

- Advertisement -