https://bugs.freedesktop.org/show_bug.cgi?id=68533
Priority: medium
Bug ID: 68533
Assignee: [email protected]
Summary: EDITING: SQL timestamp bug
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Database
Product: LibreOffice
Created attachment 84595
--> https://bugs.freedesktop.org/attachment.cgi?id=84595&action=edit
A database document which shows the explained bug.
Problem description:
I tried to use SQL command ("alter table "table name" add "col name" timestamp
default now") to acquire timestamp from system. It seems not to be working
under current version, 4.1.0.4.
Mainly, I referred this website:
http://blog.jamesrhall.com/2012/11/openoffice-libreoffice-base-timestamp.html
Steps to reproduce:
1. Open Base>tool>SQL
2. Type "alter table "table name" add "col name" timestamp default now" and
execute
3. See table
Current behavior:
The system just shows "25/08/13 00:00" and it never changes its time(00:00).
Expected behavior:
Time should be correctly updated.
Operating System: Windows 7
Version: 4.1.0.4 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs