Function Return Month

Contains tips for configurators working with Aware IM
Post Reply
himanshu
Posts: 723
Joined: Thu Jun 19, 2008 6:24 am
Location: India
Contact:

Function Return Month

Post by himanshu »

Hi,

I think Function that Return String as Month (JAN, FEB, MAR) like is not there in Date & Time Function List..

CURRENT_MONTH_OF_YEAR Function
returns: string of month name.

Require,
From,
Himanshu Jain


AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
aware_support
Posts: 7525
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Post by aware_support »

You can get around it by specifying the MMM date format when displaying your date.
Aware IM Support Team
himanshu
Posts: 723
Joined: Thu Jun 19, 2008 6:24 am
Location: India
Contact:

Post by himanshu »

How should I able to display like

Sunday, July 11, 2009
From,
Himanshu Jain


AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
aware_support
Posts: 7525
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Post by aware_support »

Aware IM uses Java notation for displaying date format. You can look up Appendix C of the User Guide or Google for "SimpleDateFormat Java". There is a detailed description of a very flexible notation.
Aware IM Support Team
jacklcs
Posts: 338
Joined: Fri Dec 31, 2010 4:20 pm

Post by jacklcs »

Post Reply