Home » SQL & PL/SQL » SQL & PL/SQL » INSERT TIME (XP)
INSERT TIME [message #343560] Wed, 27 August 2008 09:20 Go to next message
polo_sport09@hotmail.com
Messages: 3
Registered: August 2008
Location: SWEDEN
Junior Member
I have a table.. one of the columns is sysdate..

I have made a procedure-cursor thats inserts rows on this table

when i insert.. i get 27.08.2008
but i want it to be 2008.08.27

i dont have dba previl so i cant change nls lang or something..
i just want it to insert 2008-08.27

[mod-edit] bold removed.

[Updated on: Wed, 27 August 2008 13:02] by Moderator

Report message to a moderator

Re: INSERT TIME [message #343571 is a reply to message #343560] Wed, 27 August 2008 09:50 Go to previous message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
See the reply from tyler_durden in this posting

Date format

His reply applies to your query as well.

Report message to a moderator

Previous Topic: Extract data
Next Topic: query help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 12 14:39:36 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.