[Moodle] MySql - reading dates and times

[Stephen Digby]

See
 
http://docs.moodle.org/en/Calendar_block
 

 

======================================================================================
Stephen Digby, Learning Technology Manager digby.stephen.p at edumail.vic.gov.au
Cheltenham Secondary College www.cheltsec.vic.edu.au Ph: 613 955 55 955  Fx: 9555 8617
======================================================================================



Crime does not pay ... as well as politics. Alfred E. Newman 
 

  _____  

From: moodle-bounces at edulists.com.au [mailto:moodle-bounces at edulists.com.au] On Behalf Of Phil Brown
Sent: Wednesday, 3 May 2006 9:01 AM
To: 'The Moodle Users' in Schools Mailing List'
Subject: [Moodle] MySql - reading dates and times



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._______________________________________________ 
http://www.edulists.com.au  <http://www.edulists.com.au> - FAQ, resources, subscribe, unsubscribe 
Moodle Mailing List kindly supported by 
http://www.vcaa.vic.edu.au  <http://www.vcaa.vic.edu.au> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au  <http://www.vitta.org.au> - VITTA Victorian Information Technology Teachers Association Inc 



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/20060504/b50853fa/attachment.html