query oracle datetime to retrieve only date

Question

I know this is simple but am having great difficulty, I need to take a query field that is datetime and convert it so that it is only date no time.

 SELECT COSTLABR.CHARGDTTM
 FROM imsv7.costlabr

Gets me the datetime field from chargdttm but I need it to only be date, or as an alternative the time to be exactly the same for every row returned.

This has got to be simple but it is eluding me. Thanks in advance! Steven

This has been asked several times already. Be sure to check for answers before asking a question. — Ageonix, Feb 17 '16 at 23:11
@Ageonix Honestly I have been searching for hours, appartently did not hit the right key words or something, the one you linked to looks to be exactly what I was looking for! Thanks! — aquariumjunky, Feb 17 '16 at 23:14
@Ageonix - I did a search for dups and didn't find one that I thought fit the bill. — Bob Jarvis - Слава Україні, Feb 17 '16 at 23:18

score 0 · Accepted Answer · answered Feb 17 '16 at 23:13

0

You can use the TRUNC function to truncate dates:

SELECT TRUNC(COSTLABR.CHARGDTTM)
   FROM imsv7.costlabr

will set the HOURS, MINUTES, and SECONDS portions of the date column to zero, in effect changing the time to the preceding midnight.

answered Feb 17 '16 at 23:13

that worked exactly like I was hoping for thank you! – aquariumjunky Feb 17 '16 at 23:35

1 Answers1