I am using an oracle database and our date fields have a timestamp on them. i would like to disregard the timestamp. is there a way to maybe trim that off by creating a new object in the universe (but keeping it a date type)? Right now they have to enter a range of 5/31/2002 12:00:00 AM to 5/31/2002 11:59:59PM to get one days worth of data. I would like them to be able to just put the date once in the query prompt and have the report bring back all entries for that day. I want to do this without having to alter the database. Any ideas? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
date and time question
- Thread starter juliam921
- Start date
Hello Juliam,
I just checked it out, in my testuniverse on ORACLE 7.3.3
the following conversion was accepted:
TO_CHAR(<date_field> , 'DD/MM/YYYY') which gives you a list of values without the time-part (albeit as a character-field) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
I just checked it out, in my testuniverse on ORACLE 7.3.3
the following conversion was accepted:
TO_CHAR(<date_field> , 'DD/MM/YYYY') which gives you a list of values without the time-part (albeit as a character-field) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
jimbopalmer
Programmer
also an idea trunc(mydate) makes it midnight I tried to remain child-like, all I acheived was childish.
- Status
Similar threads
- Locked
- Question
- Locked
- Question