| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DATETIME default |
« View previous topic :: View next topic » |
| Author |
Message
|
| Testo |
 Posted: Wed Apr 28, 2004 7:20 am Post subject: DATETIME default |
 |
|
Centurion
Joined: 26 Feb 2003
Posts: 120
Location: Italy - Milan
|
In a CWF msgset, WMQI 2.1 CSD 3, I have the default format set at 'yyyy-MM-dd'T'HH:mm:ss'.
What does the 'T' stand for? I need a similar format with a blank instead of the 'T'.
Can I simply put 'yyyy-MM-dd HH:mm:ss' in the CWF pane in the format string row?
Thanks,
Andrea Tedone
IBM AMS
IT Specialist |
|
| Back to top |
|
 |
| Missam |
| Posted: Wed Apr 28, 2004 7:33 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
T stands for TIMESTAMP
If you don't want T in that place you can remove or replace with some other string manually.
there are couple of ways you can do it.
look into POSITION,OVERLAY,SUBSTRING functions on how to handle this |
|
| Back to top |
|
|
| Testo |
| Posted: Wed Apr 28, 2004 7:42 am Post subject: Ok but... |
|
|
Centurion
Joined: 26 Feb 2003
Posts: 120
Location: Italy - Milan
|
thanks IamSam, it's now clear the 'T' meaning.
Now I need to have an answer for the second question:
can I simply put 'yyyy-MM-dd HH:mm:ss' in the CWF pane in the format string row?
Thanks,
Andrea |
|
| Back to top |
|
|
| Missam |
| Posted: Wed Apr 28, 2004 11:03 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
| Yes if you Change the default format to 'yyyy-MM-dd HH:mm:ss' the MRM(CWF) parser expects the data in the above format. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
