Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Impromptu Date Manipulation

Status
Not open for further replies.
Rich72

Rich72

Programmer
Nov 19, 2003
2
GB
I have the situation where I am creating a catalog for a sql server 2000 database. This database stores all the datetimes in UTC(GMT). I am looking for a way to get the dates from the database into Local time for the catalog.

Any help would be much appreciated
 
Sort by date Sort by votes
Hi,

You can take the date from database and local time using
now() Impromptu function.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
439
beegeeblueboy
beegeeblueboy
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
381
tushargaurav
tushargaurav
sreevp2020
  • Locked
  • Question
dynamic deafult date in date prompt calandar
Replies
0
Views
350
sreevp2020
sreevp2020
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
336
Goutham3835
Goutham3835
dredden2
  • Locked
  • Question
COGNOS Script to modify date ranges on a Dimension
Replies
0
Views
367
dredden2
dredden2

Part and Inventory Search

Sponsor

Back
Top