[Moodle] MySql - reading dates and times

[Phil Brown]

I'm sure someone can solve this.

 

When I do an export from the mdl_user table of the MySql database in Moodle
all the date/time fields are integers. I want to put this information in an
Access database so I can better report on the usage of Moodle. Does anyone
know how to convert these numbers so that Access (or Excel) can read them as
dates and times?

 

Phil Brown

ICT Manager

Wellington Secondary College

 



Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/moodle/attachments/20060503/9f4431ac/attachment-0001.html