If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

System time

Started by esanray, 18 Nov 2011 02:10:31 AM

Previous topic - Next topic

esanray

How to display system time if the time is  20:00 then it will display 2000 format

HalfBloodPrince

Hi you can use replace function to replace : with '' after casting systime() to character. If it doesn't work then create this calculation
cast(extract(Hour,systime()),varchar(10))+''+cast(extract(minute,systime()),varchar(10)). only check the time format what you want means 12 or 24 hour.