I have a date-field where I get some raw data from another system (I have no control over the export of the other system) … the date is published in the following format:
2010-10-26T07:11:18Z
Is there a way to easily convert this format into a unix-timestamp/ee-compatible format?
I've tried {exp:query sql="SELECT UNIX_TIMESTAMP('col_id_22') AS unixtime FROM exp_matrix_data WHERE entry_id = {entry_id}"}{unixtime}{/exp:query}
but this does not work (I guess because of the T
and Z
in the raw data?