CODEWITHSUNDEEP
sqloracle-database
Shivam Kumar
Shivam Kumar

Reputation: 7

Group By DATE (Second) in Sql Plus

I have a table where I want to group by the records on the basis of seconds ? Please suggest what I can do ?

Upvotes: 0

Views: 523

Answers (1)

Gabsii
Gabsii

Reputation: 456

check out AskTOM. 

CAST(<my_ts> AS TIMESTAMP(0))

should work (as @user3863616 suggested)

Upvotes: 1

Related Questions