date format wrong fr views - ecause of: FROM_UNIXTIME()
neofactor - July 29, 2008 - 00:46
| Project: | Date |
| Version: | 6.x-2.0-beta3 |
| Component: | Date CCK Field |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Please reference this cross post... I think the bug is on datefield and not in Views.
http://drupal.org/node/288078
Under 6.x-2.0-beta3 I have a date cck field. The date format saved in the database is: 2008-10-18T00:00:00
Views using FROM_UNIXTIME() cannot read this as a valid date so it results in the date being: 1969-12-31 which of course makes your view wrong.
As I said in the Views post... this is either a format issue on DateField... or a problem with Views and the FROM_UNIXTIME function incorrectly applies localtime correction.
I would think the easy answer is to have datefield save its format like node does... like this: 1215382015
Thoughts?
#1
Use the latest -dev code, there have been lots of fixes since the beta3 version.
#2
Automatically closed -- issue fixed for two weeks with no activity.