| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How convert dynamic Time Stamp in String to TimeStamp |
« View previous topic :: View next topic » |
| Author |
Message
|
| mahesh2069 |
 Posted: Sat Sep 14, 2013 2:13 am Post subject: How convert dynamic Time Stamp in String to TimeStamp |
 |
|
Centurion
Joined: 26 Jun 2013
Posts: 103
|
Hi All,
I want to convert from Character type of Time Stamp data to TimeStamp type in ESQL.
Here problem is That character type of data changed ,from every 60 min.
| Code: |
DECLARE cacheLoadtim TIMESTAMP;
-- This statement executed Successful.
SET cacheLoadtim=CAST(DATE '2013-09-14',TIME '14:30:66.666' AS TIMESTAMP);
DECLARE cacheLoadTime TIMESTAMP;
DECLARE d CHARACTER '2013-09-14';
DECLARE h CHARACTER '14:30:66.666';
-- But If want to give dynamic , date and time It shows Syntax Error , How to resolve this issue
SET cacheLoadtim=CAST(DATE d, TIME h AS TIMESTAMP);
|
Here date and hours dynamically Changed , These values comes to me as Character format , how to covert This Character type of Date ,time to TimeStamp?
_________________
Thanks & Regards
Mahesh Mediboyina
WMB Developer |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Sat Sep 14, 2013 2:44 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
How about this for starters
| Code: |
declare t_MY_TimeStamp TIMESTAMP;
set t_MY_TimeStamp = cast(InputCharString as timestamp format 'IU');
|
You may have to change the format string to fit the time format you are actually receiving BUT this is all described in the InfoCentre.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| 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
|
|
|
|
