dbTalk Databases Forums  

Re: Playing With Truncate and Date

comp.databases.oracle.server comp.databases.oracle.server


Discuss Re: Playing With Truncate and Date in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Nimish Garg
 
Posts: n/a

Default Re: Playing With Truncate and Date - 03-08-2011 , 06:20 AM






On Mar 8, 12:49*pm, Maxim Demenko <mdeme... (AT) gmail (DOT) com> wrote:
Quote:
On 8 Mrz., 04:51, Nimish Garg <nimishs... (AT) gmail (DOT) com> wrote:

as per the suggestions, i hv added a link on my posthttp://nimishgarg.blogspot.com/2010/07/oracle-differece-between-wmcon...

In the mentioned otn thread was suggested, that you add a reference on
*all* your posts, where you used examples not invented by you. You
have added reference only on *one* your blogpost. In my previous reply
i mentioned at least one of your blogpost, which doesn't reflect the
original source as of now.



and also have removed the pagehttp://nimishgarg.blogspot.com/2010/10/count-and-count-distinct-behav...

what else i can do here ????

I have no idea what you can do, but in our country, the minister who
used other's work without paying credit, has resigned - just to
mention some possible alternatives...

Best regards

Maxim
but i hv already removed the post as suggested
and also have provided links of reference in my post

Reply With Quote
  #12  
Old   
joel garry
 
Posts: n/a

Default Re: Playing With Truncate and Date - 03-08-2011 , 10:47 AM






On Mar 7, 7:51*pm, Nimish Garg <nimishs... (AT) gmail (DOT) com> wrote:
Quote:
On Mar 7, 12:36*am, Maxim Demenko <mdeme... (AT) gmail (DOT) com> wrote:



On 06.03.2011 20:22, Michel Cadot wrote:

"John Hurley"<hurleyjo... (AT) yahoo (DOT) com> *a crit dans le message de news:
a490c259-132b-4b3a-a7f3-31f97dc0f... (AT) o21g2000prh (DOT) googlegroups.com...

For this, it would be necessary that the writer is aware of the limits
of his examples which is likely to not be the case for those that needs
to auto-promote their blog.

Regards
Michel

Well, it seems, in many cases, these aren't *his* examples, he just
sometimes forget to mention it...

http://forums.oracle.com/forums/mess...196352#9196352

At least, the pointed by Rob van Wijkhttp://nimishgarg.blogspot.com/2010/09/oracle-11g-virtual-column.html
still doesn't reflect the original otn posthttp://forums.oracle.com/forums/thread.jspa?threadID=1084628&tstart=2

Best regards

Maxim

if u see this thread herehttp://forums.oracle.com/forums/message.jspa?messageID=9196352#9196352

as per the suggestions, i hv added a link on my posthttp://nimishgarg.blogspot.com/2010/07/oracle-differece-between-wmcon...

and also have removed the pagehttp://nimishgarg.blogspot.com/2010/10/count-and-count-distinct-behav...

what else i can do here ????
Perhaps the best thing you could do is to let your local peers in the
blogging world understand concepts of fair use and giving credit where
it is due. In our brave new world of feeders and twits, frames and
links, it is not always a clear subject. The solution starts with
yourself, then spreads outwards.
http://www.principalinvestigators.or...nd-plagiarism/

I for one appreciate when people admit mistakes, fix them and learn
from them. It can only make you look better. Standing on the
shoulders of giants starts with acknowledgment.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...nd-frustrates/

Reply With Quote
  #13  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Playing With Truncate and Date - 05-07-2011 , 06:07 AM



On 03/06/2011 03:43 PM, Maxim Demenko wrote:
Quote:
On 06.03.2011 15:04, John Hurley wrote:
Michel:

# SQL> SELECT TRUNC( TO_DATE('27-FEB-2011') -1,'DAY')+1 FROM DUAL;

....ERROR at line 1: ORA-01858: a non-numeric character was found where
a numeric was expected

Works for me ...


It is just the question of time, till somebody changes nls environment
(it might be yourself).

What Michel implied (i suppose) to tell
1) it is bad to rely on implicit conversion, if you can avoid it
I do not agree with the second part of that sentence.

It Is Bad(tm) to rely on implicit conversions.

--

Regards,

Frank van Bortel

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.