User Profile

Collapse

Profile Sidebar

Collapse
Abkumsingh13
Abkumsingh13
Last Activity: Jun 18 '07, 11:55 AM
Joined: Jun 18 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Abkumsingh13
    replied to Conversion of date format
    Hi,
    I need to convert one date format to another. I am using the following query but is not working, can someone suggest the reson for the query not to work.

    select TO_CHAR(trans_d ate,'YYYY-MM-DD HH24:MI:SS') as trans_date from ln_si_addr_ex_s upport
    See more | Go to post

    Leave a comment:


  • Abkumsingh13
    started a topic Conversion of date format

    Conversion of date format

    Hi,

    i need to convert a date into another date format but when i use TO_CHAR or TO_DATE key word to convert the date format the error given is:-
    Error starting at line 1 in command:
    update ln_si_addr_ex_s upport set trans_date = to_date('03:50: 53 11 Jun 2007','YYYY-mm-DD HH24:MI:SS')
    Error report:
    SQL Error: ORA-01843: not a valid month
    01843. 00000 - "not a valid month"
    See more | Go to post
No activity results to display
Show More
Working...