| Author | Message | ||
Subzero Side Hero Username: Subzero Post Number: 4526 Registered: 04-2008 Posted From: 59.93.77.153 Rating: N/A |
select to_char(datecolumn , 'DD-MON-YY' ) from tablename in place of 'DD-MON-YY' , you can use suitable string that matches ur requirement | ||
Maverick Hero Username: Maverick Post Number: 19791 Registered: 01-2008 Posted From: 24.1.171.91 Rating: N/A |
adi correct gane insert avutundi..when u read it back use to_char with mm dd yyyy 24hh:mi:ss format select to_char(sysdate,mm dd yyyy 24hh:mi:ss) from dual | ||
Subzero Side Hero Username: Subzero Post Number: 4524 Registered: 04-2008 Posted From: 59.93.68.147 Rating: N/A |
try systimestamp in the select / insert / update statement | ||
Gharshana Junior Artist Username: Gharshana Post Number: 226 Registered: 07-2010 Posted From: 15.219.201.68 Rating: N/A |
 Waiting for Chandramuki2 | ||
Side Hero Username: Twitter Post Number: 3072 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
hmm right I was thinking the same but app lo endhuku anni 12:00:00:00 soopithundhantav ? probably this could be app related bug , let me check . Thanks any way. Thanks for all for help. | ||
Gharshana Junior Artist Username: Gharshana Post Number: 225 Registered: 07-2010 Posted From: 15.219.201.68 Rating: N/A |
na dantlo ii value vundi time stamp ki.. DD-MON-RR HH24:MI:SSXFF seems like even idle_yzag suggested the same..
actual ga oracle ki client connection tho connect aye tapudu code lo alter session use chesi time stamp marchukondi.. so connect aye tappudu ala alter session should be the first one to go and then save the dates with time.. hope this helps  Waiting for Chandramuki2 | ||
Kaisersooze Side Hero Username: Kaisersooze Post Number: 2178 Registered: 04-2009 Posted From: 68.82.254.207 Rating: N/A |
Idly nuv pampina alter ni koddhiga marchi sessin alter chesi save chesthe timstamp kanipisthundhi kaani ilanti change server meedha kooda cheyaalantara ? // brother..meeru toad vadithae dhantlo change chesi chudandi to see the values in that format..ledhu ask ur DBAs to change the paameter to your need.. katta ki katta...katta ki katta..katta ki kataa.. | ||
Idle_yzag Megastar Username: Idle_yzag Post Number: 25765 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
akkarledhu, DB lo bagane save avuthundi, you are altering to see what it is stored RahulGandhi/JP/Chiru | ||
Kaisersooze Side Hero Username: Kaisersooze Post Number: 2177 Registered: 04-2009 Posted From: 68.82.254.207 Rating: N/A |
a application use chesthunaru to insert values? r u using oracle forms? katta ki katta...katta ki katta..katta ki kataa.. | ||
Side Hero Username: Twitter Post Number: 3071 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
Idly nuv pampina alter ni koddhiga marchi sessin alter chesi save chesthe timstamp kanipisthundhi kaani ilanti change server meedha kooda cheyaalantara ? | ||
Side Hero Username: Twitter Post Number: 3070 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
oops mistake it is NLS_TIMESTAMP_FORMAT | ||
Side Hero Username: Twitter Post Number: 3069 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
NLS_CALENDAR GREGORIAN NLS_CHARACTERSET UTF8 NLS_COMP BINARY NLS_CURRENCY $ NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_DUAL_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_LANGUAGE AMERICAN NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_NCHAR_CONV_EXCP FALSE NLS_NUMERIC_CHARACTERS ., NLS_SORT BINARY NLS_TERRITORY AMERICA NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR | ||
Gharshana Junior Artist Username: Gharshana Post Number: 224 Registered: 07-2010 Posted From: 15.219.201.68 Rating: N/A |
is this time stamp format or date format ?? Waiting for Chandramuki2 | ||
Side Hero Username: Twitter Post Number: 3068 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
NLS_DATE_FORMAT = DD-MON-RR NLS_DATE_FORMAT = DD-MON-RR HH.MI.SSXFF AM | ||
Gharshana Junior Artist Username: Gharshana Post Number: 223 Registered: 07-2010 Posted From: 15.219.201.68 Rating: N/A |
select * from v$nls_parameters idi chesi results post cheyi Waiting for Chandramuki2 | ||
Idle_yzag Megastar Username: Idle_yzag Post Number: 25759 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
yes but you might be seeing wrong values when you run "SELECT" query RahulGandhi/JP/Chiru | ||
Side Hero Username: Twitter Post Number: 3067 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
Kaiser actually application nunchi insert ainavi kooda ilaage vasthunnai ante App run ayye box meedha kooda ee NLS settings marchalantara ? we don't have control on that kadha . NLS settings client specific kadha . | ||
Idle_yzag Megastar Username: Idle_yzag Post Number: 25758 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
try this, set your session date format alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss' RahulGandhi/JP/Chiru | ||
Septictank Junior Artist Username: Septictank Post Number: 315 Registered: 09-2007 Posted From: 122.169.165.177 Rating: N/A |
ohhhh nenu vachee lopee froblem solve ayyindaaa  | ||
Side Hero Username: Twitter Post Number: 3066 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
yeah Toad use chesthunna , but SQL+ lo kooda anthe vasthundhi | ||
Gharshana Junior Artist Username: Gharshana Post Number: 222 Registered: 07-2010 Posted From: 15.219.201.68 Rating: N/A |
good points to be noted .. Twitter idi check cheste betterWaiting for Chandramuki2 | ||
Kaisersooze Side Hero Username: Kaisersooze Post Number: 2164 Registered: 04-2009 Posted From: 68.82.254.207 Rating: N/A |
toad vadithae date format option change cheyandi..lekapothae NLS_Date parameter a format lo vudho chudu.. katta ki katta...katta ki katta..katta ki kataa.. | ||
Idle_yzag Megastar Username: Idle_yzag Post Number: 25756 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
nuvvu yemina editor vaduthunava? direct SQL Plus run chey query RahulGandhi/JP/Chiru | ||
Gharshana Junior Artist Username: Gharshana Post Number: 221 Registered: 07-2010 Posted From: 15.219.201.68 Rating: N/A |
Hmm .. interesting .. I tested right away but its working fine !! Example::: SQL: -> create table check_time (bb timestamp(6)); Table created. SQL: -> select * from check_time 2 / no rows selected SQL: -> insert into check_time values (sysdate); 1 row created. SQL: -> select * from check_time 2 / BB ------------------------------------------------------------ --------------- 03-AUG-10 07.20.01.000000 PM SQL: -> insert into check_time values (systimestamp); 1 row created. SQL: -> select * from check_time 2 / BB ------------------------------------------------------------ --------------- 03-AUG-10 07.20.01.000000 PM 03-AUG-10 07.21.05.204120 PM SQL: -> Is this the same thing which is giving wrong values to u ?? Waiting for Chandramuki2 | ||
Idle_yzag Megastar Username: Idle_yzag Post Number: 25753 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
naku question ardam avaledhu, but her eis what I tried create table mga_tmp_exch(abc timestamp(6)); insert into mga_tmp_exch values (timestamp'2010-01-10 09:00:00.123456') insert into mga_tmp_exch values (sysdate) commit select * from mga_tmp_exch ABC ------------------------------------------------------------ --------------- 10-JAN-10 09.00.00.123456 AM 03-AUG-10 05.15.46 PM RahulGandhi/JP/Chiru | ||
Side Hero Username: Twitter Post Number: 3065 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
nee id gamananincha ledhu dhaanemma jeevitham kikki | ||
Side Hero Username: Twitter Post Number: 3064 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
checked this but this is not the case, although there will be difference because server times are UTC times . | ||
Side Hero Username: Twitter Post Number: 3063 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
// have so many other columns of same data type (timestamp(6)) // timestamp(6) | ||
Pomegranate_life Junior Artist Username: Pomegranate_life Post Number: 104 Registered: 07-2010 Posted From: 32.97.110.60 Rating: N/A |
Oracle uses OS date & time so check this with the sysdate function. so check your OS time | ||
Idle_yzag Megastar Username: Idle_yzag Post Number: 25751 Registered: 02-2008 Posted From: 198.80.144.187 Rating: N/A |
nuvvu insert chese column datatype Date aa DateTime aa? RahulGandhi/JP/Chiru | ||
Side Hero Username: Twitter Post Number: 3062 Registered: 10-2009 Posted From: 151.191.175.207 Rating: N/A |
Guys trying to record date time with timestamp but it is not recording correct time showing only date part correctly time is always recorded as some default time 12:00xxx , I tried formatted systimestamp and sysdate using to_date and to_char but no use. I have so many other columns of same data type (timestamp(6)) but all of those are saved by the time sent by the application no problems here, but if I use sysdate and systimestamp then only the problem arises. koddhiga urgent light eyyandi .. |