![]() Gen_data is just something I have to generate random data - that generated 500 "bad" rows for us, rows that will not be dates (almost insert into t select to_char(created,'yyyymmdd'), to_char(created,'hh24:mi:ss' )Īnd that created 14,773 "good" rows for create or replace function my_to_date( p_num in number, p_str in varchar2 ) return dateĤ return to_date( p_num || p_str, 'yyyymmddhh24:mi:ss' ) Here is an example create table t ( calldate number, calltime varchar2(8) ) || '"' trick is something I frequently do to see whats up with the data (dump(to_char(dt,'DAY')) would be useful as well) If you use the fm (format modifier) mask - you'll get what you want. Since Mittwoch is not as long as Wednesday. Now, a user in Germany might be confused by your alter session set nls_language=German ![]() It has EVERYTHING to do with how the format mask you used formated the '"'||TO_CHA DTħ rows works cause (in our language), it is the longest. It has nothing to do with how the date data is saved (it is saved in a 7 byte binary format with century, year, month, day, hour, minute, second and in 9i upto 11 bytes with fractional seconds.
0 Comments
Leave a Reply. |