Hoe to change the date format
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