Skip to Content
Former Member
Oct 21, 2008 at 06:18 AM

Hoe to change the date format


Hi friends,

Hope all are good,

I have one issue in date format. In my database i have the date format like this. yyyy-mm-dd h:mm:ss.0000 like this, it contains all hours and minutes,seconds information. But when i use this date in the webi, it display like this mm-dd-yy, then i changed the format in universe, then it display like this yyyy-mm-dd 00:00:00:.0000, instead of hour miutes seconds it display's only zeros.

The same date i used as a filter in the report as well. is there any way to handle this. Otherwise how can i change the date format.Becoz based on the hour minute second only my client needs to filter the data.

Plz advise me

Thanks lot,