CODEWITHSUNDEEP
sqlteradata
JackSkellington88
JackSkellington88

Reputation: 13

SQL extracting hour and minute from date into a single column

I have a column in the format YYYY-MM-DDBHH:MI:SS and I wish to extract just the hour and minutes from this into a column. Currently on the code they are using

 Extract(HOUR From table) AS HR
, Extract(MINUTE From table) AS MN

but this outputs them into 2 columns. I'm new to SQL so is there an easier way to extract hour and minutes into one column in the format HH:MI.

Thanks

Upvotes: 1

Views: 2802

Answers (3)

dnoeth
dnoeth

Reputation: 60472

If you got a Timestamp the easiest way to get a HH:MI string is: 

to_char(mycol, 'HH24:MI')

Upvotes: 0

Martin
Martin

Reputation: 16433

Using Teradata, simply concatenate the output from each of the functions to give the answer:

Extract(HOUR From table) || ':' || Extract(MINUTE From table) AS OUTPUT

Upvotes: 2

MD AZAD HUSSAIN
MD AZAD HUSSAIN

Reputation: 212

Don't know about teradata but something like this.

SELECT CONCAT(Extract(HOUR From table),Extract(MINUTE From table)) as HRandMI

Upvotes: 0

Related Questions