MQSeries.net :: View topic - ESQL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL - CURRENT_TIME

ESQL - CURRENT_TIME

« View previous topic :: View next topic »

Author

Message

fcotait

Posted: Thu Feb 13, 2003 9:41 am Post subject: ESQL - CURRENT_TIME

Acolyte

Joined: 28 Feb 2002
Posts: 63
Location: Sao Paulo - Brazil

Hi,

I need to get the value "seconds" from local time.

CAST(EXTRACT(SECOND FROM CURRENT_TIME) AS CHARACTER);

but this is returning "3,4953E+1". I would like to get the decimal value

any idea

thanks

Filipe Cotait

yaakovd

Posted: Fri Feb 14, 2003 3:08 am Post subject:

Partisan

Joined: 20 Jan 2003
Posts: 319
Location: Israel

Try this:
CAST( EXTRACT(SECOND FROM CURRENT_TIME) AS INTEGER
or
SUBSTRING((CAST(100 + EXTRACT(SECOND FROM CURRENT_TIME) AS CHARACTER)) FROM 2 FOR 3)
If you need fixed format. You will receive 00, 01, 02 ... 59.
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL - CURRENT_TIME

Jump to:

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

Protected by Anti-Spam ACP