SELECT DATE From DB2 - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> SELECT DATE From DB2

Reply

Search this Thread

#1 (permalink)

Old

11-22-04, 16:33

akosz

akosz is offline

Registered User

Join Date: Sep 2004

Posts: 50

SELECT DATE From DB2

In SQL Server I can do the following to get the date from any given database:

Code:

SELECT DATE = getdate();

Does anybody know of a DB2 equivalent?

Reply With Quote

#2 (permalink)

Old

11-22-04, 16:39

Brett Kaiser Brett Kaiser is offline

Brett Kaiser is offline

Window Washer

Join Date: Nov 2002

Location: Jersey

Posts: 10,303

SELECT CURRENT TIMESTAMP FROM sysibm.sysdummy1

__________________
Brett
8-)

It's a Great Day for America everybody!

dbforums Yak Corral Radio 'Rita
dbForums Member List
I'm Good Once as I ever was

The physical order of data in a database has no meaning.

Reply With Quote

#3 (permalink)

Old

11-23-04, 00:23

Santosh Kumar Santosh Kumar is offline

Santosh Kumar is offline

Registered User

Join Date: Sep 2004

Posts: 6

or VALUES CURRENT TIMESTAMP ;

Reply With Quote

#4 (permalink)

Old

11-23-04, 13:42

akosz

akosz is offline

Registered User

Join Date: Sep 2004

Posts: 50

that worked, thanks to both of you for your help.

Santosh - do you live in the toronto area by any chance? your name sounds familiar.

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules