Contains tips for configurators working with Aware IM
himanshu
Posts: 723 Joined: Thu Jun 19, 2008 6:24 am
Location: India
Contact:
Post
by himanshu » Sun Jun 28, 2009 4:32 pm
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 » Tue Jun 30, 2009 1:17 am
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 » Wed Jul 01, 2009 6:47 pm
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 » Thu Jul 02, 2009 12:06 am
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