I am working in Oracle SQL Developer and have the following code
SELECT Trunc(assigned_date, 'IW') AS bonus_week FROM (SELECT Trunc(blf.assigned_date) AS assigned_date FROM olap.bonus_lifecycle_fact blf)
I get output in this form
07-12-03 08-01-28 08-01-28 08-01-28 08-01-07
Which is DD-MM-YY
That's fine, except when I export to Excel I get some wonky stuff happening.
eg: 08-01-28 becomes 08-01-2028.
I presume it is because blf.assigned_date is a timestamp but I'm not sure to rectify it. Any and all help appreciated. Thanks!