Link to home
Start Free TrialLog in
Avatar of theideabulb
theideabulbFlag for United States of America

asked on

Date Insert

What formatting, or what do i need to do to get my date to look like this in the mySQL database?

1303623202

I will be inserting from another table that has a format  like this:

4/28/2011 2:14:54 PM

Does that matter?
Avatar of Sharath S
Sharath S
Flag of United States of America image

How did you get 1303623202 from 4/28/2011 2:14:54 PM? What is the logic?
ASKER CERTIFIED SOLUTION
Avatar of mankowitz
mankowitz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of theideabulb

ASKER

Sharath, i had no idea how that was being insert into the db myself.  Not sure what the reasoning is behind that type of format either.  This is what the ExpressionEngine CMS system does.

mankowitz, thank you, i will give that a shot.
Great job.

I actually used a UDF from CFLIB.org

http://cflib.org/udf/GetEpochTime