Site Date Conversion

OK if I have this date what format does it take to insert that into the database?

I have date specific data and want to inject dates into the corresponding records what is the date format that Dolphin uses to convert the above date to a readable format by the dolphin system?

IS there a site to convert a large list of dates?  Thank you if you can provide this for me....

There really is no specific answer for that because your question is not specific enough.

Dates can be stored in the database in a number of different ways. And which way is used depends on how the module expects it to be.

For example. If these dates are used in the profile, then the profile table takes it's dates in mysql's datetime format. 2011-11-20 15:32:24   Which is YYYY-MM-DD HH:MM:SS

Other areas of dolphin may require it be different. For example most of my module that store a date i store in either a mysql varchar or bigint becuse i store my dates as a UNIX time stamp 1321796100 which is the number of seconds past since standard epoch of 1-1-1970. I use this format becuse it's easy to work with in php becuse all of the date and time functions work with it.

So i guess you need to state specifically where your storing it. In a profile, module or something custom you're doing.

It is a module which has a created date and a sold date the working created dates look like this:

1311549497  I assume that is the UNIX time stamp.            I just assume the sold date would be the same format...................

At this point I need the created date first.................I will look for a converter

 Kotter said it best:

ASSUME

ASS | U | ME

is the field available on the database, and you are just needing to insert the corresponding sold date? there is nothing to convert a batch date that i know of. if you have a date format that you are trying to insert, then you can use excel to set the datestamp format.

if the field does not exist on the database, then you need to create the column, and specify the datum structure for that field. yes, the number you mention is a unix time stamp.

 http://www.epochconverter.com/epoch/batch-convert.php

i did in fact find a batch convertor for unix timestamps