Web lists-archives.com

Re: [PHP] Converting a "timestamp"




In SQL language you still can take Aziz example to perform this:
UPDATE MyTable SET MyDate = CONCAT(SUBSTRING(MyDate, 1, 4), '-',
SUBSTRING(MyDate, 6, 2), '-',...);

The result will be complete conversion of original rare format to your
customized format.


El 19/02/17 a les 04:34, Jennifer ha escrit:
>> On Feb 18, 2017, at 12:47 PM, Don Wieland <donw@xxxxxxxxxxxxx> wrote:
>>
>> function convert_stamp($stamp) {
>>     $ta = explode(‘|’, $stamp);
>>     return $ta[‘0’].’-‘.$ta[‘1’].’-‘.$ta[‘2’].’ @ ‘.$ta[‘3’].’:‘.$ta[‘4’].’:‘.$ta[‘5’];
>> }
> 
> 	Thanks for the function, Don.  That did end up coming in handy, but my main question was about getting the data out of MySQL and then back in, which I couldn’t really solve.  I could get the data into an array and massage it, but I couldn’t figure out how to get it back in.  So I ended up just exporting the data from the table, manipulating the file in PHP, then importing back into the table.  A round about way, but at least it’s done.
> 
> Jenni
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php