SQL SERVER GET CURRENT TIME

The following code reads the current system time into a variable:

declare @time as nvarchar(50)

 

select @time = CONVERT(char(5), CURRENT_TIMESTAMP,8)

Print @time

The time will be stored / displayed in the following format:

14:03

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s