Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

date format

stebabstebab Member Posts: 2
i don't know how to change the default date format in oracle.......
no througt alter session... but i need stg else.....

Comments

  • rikb53rikb53 Member Posts: 67 ✭✭

    depends you can do the ALTER SESSION set NLS dATEFORMAT COMMAND
    that will change it for the session

    or do it as it comes up

    like a table with name, id and a balance date.

    select name, id, to_date(balance_date, 'dd/mm/yyyy')

    or you can convert it.
    select name,id,to_char(balance_date, 'hh24:mi:ss')
    so it wouldnt even be a date any more just hours, mins seconds

    : i don't know how to change the default date format in oracle.......
    : no througt alter session... but i need stg else.....
    :

Sign In or Register to comment.