You can use string functions with the standard formats if you really want this.
Otheriwse if you have flexibility using a standard format is definitely easier. Note that when this is char you can aggregate or expect it to sort correctly at all. Picking something that sorts properly may not be a bad idea.
Functions
DATEPART, TIMEPART to convert or components
Day, Month, Year () respectively extract the names components.
Formats:
DOWNAME3 -> Mon, Tue, Wed, etc
wordatex. -> 5 March 2016 (if you want the 3 char month try specifying a length of 11. Not sure if it will work)
MONNAME3 -> 3 character month, Jan, Feb, Mar, etc.
For the time, TIMEAMPM7.
You can use CATX() to combine components.
All the ingredients are there, some assembly required 😄
... View more