Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can you display the current date & current time ?

Answers were Sorted based on User's Feedback



How can you display the current date & current time ?..

Answer / chandrika

Exec sql
set :ws-current-date to current date
End exec

display 'current date' ws-current-date.



Exec sql
set :ws-current-time to current time
End exec

display 'current time' ws-current-time.

Is This Answer Correct ?    7 Yes 1 No

How can you display the current date & current time ?..

Answer / damy

select sysdate from dual;

Is This Answer Correct ?    5 Yes 0 No

How can you display the current date & current time ?..

Answer / prabu

select getdate()

In SQL Server, We can get current date and time
If this answer is not correct give me feedback

Is This Answer Correct ?    2 Yes 0 No

How can you display the current date & current time ?..

Answer / raghu

select currentdate,currenttime from sysibm.sysdummy
the above date and time are scalar functions and it from the timestamp

Is This Answer Correct ?    2 Yes 0 No

How can you display the current date & current time ?..

Answer / g.naveen

ASKTIME is command used to display the current Date & Time

Is This Answer Correct ?    5 Yes 4 No

How can you display the current date & current time ?..

Answer / umesh

you can ge the current date and time by using the command

date

Is This Answer Correct ?    1 Yes 0 No

How can you display the current date & current time ?..

Answer / ganesh kumar

Answer
# 1

ASKTIME is command used to display the current Date & Time

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More DB2 Interview Questions

How do I import data from excel to db2?

0 Answers  


How are write I/Os from the buffer pool executed?

1 Answers  


What is CHECK PENDING ?

5 Answers  


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


What is the physical storage length of timestamp data type?

0 Answers  


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,


which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  


What is the difference between bind and rebind in db2?

0 Answers  


can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,


What happens in bind step in a db2 program?

0 Answers  


how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


Categories