Skip to content

Instantly share code, notes, and snippets.

@steveosoule
Last active August 29, 2015 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save steveosoule/78c9e569495d550e0341 to your computer and use it in GitHub Desktop.
Save steveosoule/78c9e569495d550e0341 to your computer and use it in GitHub Desktop.
Miva Toolkit MySQL DATETIME Format
<mvt:item name="toolkit" param="set_time_zone|our_time|-7" />
<mvt:item name="toolkit" param="time_t_year|year|our_time" />
<mvt:item name="toolkit" param="time_t_month|month|our_time" />
<mvt:item name="toolkit" param="padl|month|month|2|0" />
<mvt:item name="toolkit" param="time_t_dayofmonth|day|our_time" />
<mvt:item name="toolkit" param="padl|day|day|2|0" />
<mvt:item name="toolkit" param="time_t_hour|hour|our_time" />
<mvt:item name="toolkit" param="padl|hour|hour|2|0" />
<mvt:item name="toolkit" param="time_t_minute|minute|our_time" />
<mvt:item name="toolkit" param="padl|minute|minute|2|0" />
<mvt:item name="toolkit" param="time_t_second|second|our_time" />
<mvt:item name="toolkit" param="padl|second|second|2|0" />
<mvt:assign name="g.datetime" value="g.year $ '-' $ g.month $ '-' $ g.day $ ' ' $ g.hour $ ':' $ g.minute $ ':' $ g.second" />
&mvt:global:datetime;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment