how to get present time and date?

[vin2sara]

Hi,

Can anyone send a query to get present date and time ??I used dateformat method ,but i am not getting that.please its very urgent to me...

Thank You

[Bhanu Murthy]

Hi,

Can anyone send a query to get present date and time ??I used dateformat method ,but i am not getting that.please its very urgent to me...

Thank You

Hello My dear,

select TO_CHAR(new_tim e(sysdate,'GMT' ,'PST'), 'DD-MON-YYYY HH:MI:SS') FROM DUAL;

You try the above... this solves your problem.
Bhanu Murthy

[vssp]

hai try this query

SELECT NOW(), SLEEP(2), NOW();

[Bhanu Murthy]

hai try this query

SELECT NOW(), SLEEP(2), NOW();

Sorry, This does not work. ... I am afraid, which ORACLE version r u using. .. May be you are using latest version... I am still using oracle 8.0.3.0.

[Bhanu Murthy]

Please try the following: (I found you have not opened the forum)

select TO_CHAR(new_tim e(sysdate,'GMT' ,'PST'), 'DD-MON-YYYY HH:MI:SS') FROM DUAL;

You try the above... this solves your problem.
Bhanu Murthy

[vampirus87]

Please try the following: (I found you have not opened the forum)

select TO_CHAR(new_tim e(sysdate,'GMT' ,'PST'), 'DD-MON-YYYY HH:MI:SS') FROM DUAL;

You try the above... this solves your problem.
Bhanu Murthy

Dear Mr. Bhanu Murthy,

Thank you for your kind reply. I have an enquiry regarding the time finding query. If I want to do a database to take the attendance of school children, i.e. let them key in their ID and select IN or OUT option. When they choose one of the option the system automatically stores the current time. How do I code for this?

[debasisdas]

you need to use SYSDATE for the purpose and set the default vaule of the DATE field to sysdate.

[sheshk11]

Hello sir

select TO_CHAR(new_tim e(sysdate,'GMT' ,'PST'), 'DD-MON-YYYY HH:MI:SS') FROM DUAL;

You try the above... this solves your problem.
Bhanu Murthy

Sir, that code you mentioned above retrieves the time of when the database was installed and its a time consuming and too complicated. Here, you can try this code if you please to; select systimestamp from dual;

[udarajag]

select SYSTIMESTAMP from dual; this would do the trick

[bharthi]

use this query to see present data and time,

select systimestamp from dual;

[mit dahime]

you try this
SELECT to_char(sysdate ,'GMT','PST'), 'DD-MON-YYYY HH:MI:SS') FROM DUAL;