|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 25th, 2005, 01:22 AM
|
|||
|
|||
Urgent -How to save not latin dates?
Hi there,
Is there anybody knows how can I save not latin dates in Oracle? I mean for example: Jalali(shamsi) calender or Arabic Calender(Hijri) instead of using Julian Calendar. Currently we do this by saving this dates in varchar type and another equivalent Latin datetime(e.g. 2 columns).We perform operations on Latin and then manipulate the varchar column and ofcourse application always will see this varchar column. -Thanks alot
|
|
#2
July 25th, 2005, 02:54 AM
|
||||
|
||||
|
You need to use NLS and set the appropriate session parameters, see this as an example.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Urgent -How to save not latin dates? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
