I need query based on Timestamp in sqlserver

Question

In Sql server: I have a fields Timestamp field (128365920). ID, Customer name. i need to based on Timestamp field.

How to write a query based on Timestamp Year, Month, Quarters, Days, Hours, Minutes  and include all fields,

Query output:

ID, Customer name, Timestamp, Year, Quarter, Day, Hour, Minitues, Sec

Please help on this query to importing to Power bi.

Answer 1

Hello  vnk,

To get some familiarity try creating and selecting a few TIMESTAMPS below.

 I was born on May 1st, 2020 at exactly 4:15am. so you fetch that timestamp bt the below query:

SELECT TIMESTAMP '2020-05-01 04:15:21';

And to add ID and customer name here is the query:

SELECT ID,customer name,TIMESTAMP '2020-05-01 04:15:21';

Hope it helps!!

Thank You!