Hi,

this is a session level operation in Oracle:

ALTER SESSION SET NLS_CALENDAR='PERSIAN'

/

And that is it Refer to globalization document at http://tahiti.oracle.com...

Sorry for fuzzy question!

It doesn't know the user account I enter.The user is one of OS users that I have used by "Local users and Groups" in windows.

Any...

Thanks for your replies but this is not my case.You can't apply min() function always.Assume that I want to order by <3_varchar_columns_here>.

I think I am not clear enough,I am not...

Lets think in reverse form! I have a procedure that returns a heavy cursor(not just like st_helpdb).Sould I transfer such a set to client (This can be application server or...

Thank all for your replies,

I have read it in a SQL Server 2000 book.I considered it to be uptodate but it seems some DBAs(authors) are stick to older versions...

Hi thanks all for replies,

 When I said it is not logged,I mean the log by our application,which means some inserts into a table called LogTable.

 I did not mean log entries...

Thanks Gabor Nyul,

Let me explain the way I know in Oracle:It supports at least 5 other calendar formats such as Persian,Arabic Hijri,English Hijri,Japanes Imperial,ROC in addition to Gregorian calendar.You...