Bug 90560 - Date Field in SQL - query looks different between View and Query
Summary: Date Field in SQL - query looks different between View and Query
Status: RESOLVED DUPLICATE of bug 88930
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.4.2.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-10 21:17 UTC by Ulf
Modified: 2015-04-14 08:12 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Picture that show the difference (87.38 KB, image/png)
2015-04-10 21:17 UTC, Ulf 		Details
Database file (5.92 KB, application/vnd.sun.xml.base)
2015-04-10 21:18 UTC, Ulf 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***