Bug 90560

Summary: Date Field in SQL - query looks different between View and Query
Product: LibreOffice Reporter: Ulf <ulger>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: medium    
Version: 4.4.2.2 release   
Hardware: Other   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Picture that show the difference
Database file

Description Ulf 2015-04-10 21:17:26 UTC
Created attachment 114729 [details]
Picture that show the difference

The same SQL - query looks different between created and opened as Table View or created and opened as a regular query. Please take a look at the attached screen shot.

1) On the left hand side you can see the SQL created and opened as Table View. You can see an Datefield wich has the right Date Format. 

2) On the other side the SQL created and opened as a regular query. Here you can see the same Datefield wich has no Date Format.

I use Win 8.1 and attached the Base file
Comment 1 Ulf 2015-04-10 21:18:18 UTC
Created attachment 114730 [details]
Database file
Comment 2 Ulf 2015-04-14 08:12:37 UTC
It looks for me like a duplicate of BUG 88930
https://bugs.documentfoundation.org/show_bug.cgi?id=88930

I made a similar  Query how to decribe the problem there.

*** This bug has been marked as a duplicate of bug 88930 ***