I have a date/time object which I am using in a parameter (between dates 1 and date 2).
The problem I am encountering is that, whilst a user can enter a time and a date, the SQL that is generated includes only the date component. The time is completely truncated!
Does anyone know if this is due to the use of the calendar object that appears and if so, whether there is any way of disabling it for particular objects?
Thanks in anticipation.
Jacqui_B (BOB member since 2009-03-19)
Hi,
It might be truncted in ETL level ,please check with ETL guys
Thanks,
Unknown 
lokesh120183 (BOB member since 2009-11-17)
Hi,
If it is predefined promt please check did you mentioned time also in the to_date conversion
to_date(Date,‘YYYYDDMM HH:MM:SS’) some thing like this.
Also check in the Data Base the Date field is capturing the time too see the structure of that coloumn in DB
Thanks,
Madhu.
madhu@P (BOB member since 2008-08-04)
Hello and thanks for your replies.
I am simply using a dimension object in the query panel (not a pre-defined filter) and using the ‘between’ option. The object references a date/time field in the databse.
The truncation of the time element occurs even if the user selects a date/time from a list of values.
cheers,
Jacqui
Jacqui_B (BOB member since 2009-03-19)