manipulating mysql date format

«

Previous topic

|

|

Next topic

»

Author	Message
Michael Hall	Wednesday 02 January 2008 6:28:12 pm Just wondering if there is a built-in template operator or similar that can rewrite a date in YYYY-MM-DD format to DD-MM-YYYY (or similar)? We're using v 3.9.3.
Atle Pedersen	Thursday 03 January 2008 9:37:00 am As far as I know there are no methods to convert a date input string to a timestamp and then into a date in a different format. But if your example represents the real problem, you could use string manipulation instead. The explode() operator kan split your string into arrays around the '-'. Then you can rewrite the array in any order you'd like to.
André R.	Thursday 03 January 2008 11:08:30 am If you need to do more advance stuff with the dates you can use the makedate / maketime template operators to get a unix timestamp out of it. eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Piotrek Karaś	Thursday 03 January 2008 11:19:11 am And at worst you can always try this: {'2008-11-22'\|explode('-')\|reverse()\|implode('-')} ;) -- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu
Michael Hall	Thursday 03 January 2008 5:15:59 pm Thanks for the info. I know this is a trivial task, I thought maybe there was an even easier way.

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 30 2025 21:44:22
Script start
Timing:	Jan 30 2025 21:44:22
Module start 'layout'
Timing:	Jan 30 2025 21:44:22
Module start 'content'
Timing:	Jan 30 2025 21:44:22
Module end 'content'
Timing:	Jan 30 2025 21:44:22
Script end

Main resources:

Total runtime	0.0208 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0051	588.1328	151.2109
Module start 'layout'	0.0051	0.0034	739.3438	220.6875
Module start 'content'	0.0085	0.0108	960.0313	1,001.8203
Module end 'content'	0.0193	0.0015	1,961.8516	33.9922
Script end	0.0207		1,995.8438

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	12.2585	14	0.0002
Check MTime	0.0010	4.9254	14	0.0001
Mysql Total
Database connection	0.0007	3.3663	1	0.0007
Mysqli_queries	0.0028	13.4353	3	0.0009
Looping result	0.0000	0.0482	1	0.0000
Template Total	0.0010	4.9	1	0.0010
Template load	0.0008	3.8669	1	0.0008
Template processing	0.0002	0.9966	1	0.0002
Override
Cache load	0.0006	2.6820	1	0.0006
General
dbfile	0.0002	1.2032	8	0.0000
String conversion	0.0000	0.0344	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs