URGENT: Date Question

[Mark Hewitt]

I am going to be transferring some posts (quite a few) across from someone elses discussion forum system (which is remotely hosted) to my own system.

I can of course do this by just posting each of the messages as if they were a new post however this does not take into account the dates the dates are only available to me in the format

19/06/00 07:55PM

However in 1.1.2 this is not the way they appear in the database so I can't alter the times in this way.

Bascially I need some way to convert a time in the above format into the type of time stored in the vBulletin database.

PLEASE!, THIS IS V.IMPORTANT :)

[John]

You can use two MySQL functions to do this:

numericdate = UNIX_TIMESTAMP('nice date')

nicedate = FROM_UNIXTIME(numericdate)

John