Date and time of the

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Wed, 07 Jun 2006 2:59 pm

Guys, I have an embarrassing situation. I found the following in a procedure: Select to_char (sysdate, ' DD/MM/YYYY hh24: mm: ss ').

This brings me the date and time of the system at that moment. But when I run this same procedure some time after, the time does not change. Keep bringing the same previous time. It appears that is recorded in any area of memory of Oracle. This is hurting my routine because it causes confusion for users. Does anyone have any idea what's going on and how can I fix this? Thank you very much.

Marlon
Marlon Pasquali
Location: Erechim - RS

Poston Sat, 10 Jun 2006 6:26 pm

Look, I don't know if you can be that, but your select seems to have an error in the minutes.

Instead of being: Select to_char (sysdate, ' DD/MM/YYYY hh24: mm: ss ').

Try: Select to_char (sysdate, ' DD/MM/YYYY hh24: mi: ss ').
omoussa
Location: SP

Omar

Poston Sat, 10 Jun 2006 6:30 pm

That's right! MM is Month! MI is minute. :-)
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Mon, 12 Jun 2006 9:31 am

beleza guy?that's what it was.Thanks many thanks Marlon
Marlon Pasquali
Location: Erechim - RS


  • See also
    Replies
    Views
    Last Post


Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 10 guests