ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 2 matches
Author Message
  Topic: POSIX Dateformat in ESQL (seconds after 1.1.1970)
zuercherd

Replies: 1
Views: 1673
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Mar 21, 2002 8:31 am   Subject: POSIX Dateformat in ESQL (seconds after 1.1.1970)
ok, it's less complicated than I thought

DECLARE posix INTEGER;
SET posix = CAST (((CURRENT_DATE - DATE '1970-01-01') DAY) * 24 * 3600 AS INTEGER) + CAST(CURRENT_TIME - TIME '00:00:00') SECOND AS ...
  Topic: POSIX Dateformat in ESQL (seconds after 1.1.1970)
zuercherd

Replies: 1
Views: 1673
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Mar 21, 2002 1:21 am   Subject: POSIX Dateformat in ESQL (seconds after 1.1.1970)
in a WMQSI 2.1/ComputeNode I have to calculate the current time in Posix Format (seconds after 1.1.1970).

I suppose there is no ESQL function to do this...
Does somebody has the algorithm? (other ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.