[opencms] [opencms-dev] Convert CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED toMYSQL date or timestamp

[Jorge González]

[auto-answer mode on]

I've solved it this way:

select FROM_UNIXTIME(ROUND(CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED / 1000))


[auto-answer mode off]


-----Mensaje original-----
De: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org]En nombre de Jorge González
Enviado el: jueves, 25 de mayo de 2006 18:51
Para: OpenCms mailing list (E-mail)
Asunto: [opencms] [opencms-dev] Convert
CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED toMYSQL date or timestamp


Hi list:

I'm working on several content reports (using ireport, by the way) and i
need to convert

CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED  --->   DATE in mysql

Any clues about this ?

I want to show in my reports the last modified contents by date.

Thanks


_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev