Get current time without Date

sql sybase
Moudiz picture Moudiz · Dec 16, 2016 · Viewed 14.7k times · Source

How do I get the current time only? 

select getdate()

Gives me:

Dec 16 2016  5:41PM

I want this result:

5:41PM

Answer

Siyual picture Siyual · Dec 16, 2016

You can convert the GETDATE() results to a TIME datatype to pull the current time:

Select Convert(Time, GetDate())

Related questions

Convert INT to VARCHAR SQL

I am using Sybase and I am doing a select which returns me a column called "iftype", but its type is int and I need to convert into varchar. When I try to do the select without the convert function …

Read More
Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF

I have the below error when I execute the following script. What is the error about, and how it can be resolved? Insert table(OperationID,OpDescription,FilterID) values (20,'Hierachy Update',1) Error: Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value …

Read More
From a Sybase Database, how I can get table description ( field names and types)?

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks.

Read More