Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
comp.databases.sybase
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Convert Hijri Date to Gregorian Date
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Rosh  
View profile  
 More options Jul 12 2012, 2:16 am
Newsgroups: comp.databases.sybase
From: Rosh <diasros...@gmail.com>
Date: Wed, 11 Jul 2012 23:16:38 -0700 (PDT)
Local: Thurs, Jul 12 2012 2:16 am
Subject: Convert Hijri Date to Gregorian Date
Print | Individual message | Show original | Report this message | Find messages by this author
Hi Experts,

I wanted help with converting Hijri Date to Gregorian Date and visa
versa in Sybase.

A lot of googling helped me find how to do it in Oracle,

select to_char(sysdate,'DD/MM/YYYY','NLS_CALENDAR=''Arabic
Hijrah''') ,to_char(sysdate,'DD/MM/
YYYY','NLS_CALENDAR=''Gregorian''')
from dual

If any one has any clue how it can be done in Sybase will be greatly
appreciated.

Cheers,
Rosh


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
bret@sybase.com  
View profile  
 More options Jul 13 2012, 3:53 pm
Newsgroups: comp.databases.sybase
From: "b...@sybase.com" <b...@sybase.com>
Date: Fri, 13 Jul 2012 12:53:38 -0700 (PDT)
Local: Fri, Jul 13 2012 3:53 pm
Subject: Re: Convert Hijri Date to Gregorian Date
Print | Individual message | Show original | Report this message | Find messages by this author

There is nothing direct built-in at this time.  The easiest way
to do it would probably be to enable the ASE Java feature and import
a Java class that can do the conversion.  I found several
possible implementations via google without any trouble.

-bret


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
diasros...@gmail.com  
View profile  
 More options Jul 15 2012, 4:51 am
Newsgroups: comp.databases.sybase
From: diasros...@gmail.com
Date: Sun, 15 Jul 2012 01:51:21 -0700 (PDT)
Local: Sun, Jul 15 2012 4:51 am
Subject: Re: Convert Hijri Date to Gregorian Date
Print | Individual message | Show original | Report this message | Find messages by this author

Thanx for the reply Bret... Enabling Java is not an option for us...
can u throw some more light on " I found several
possible implementations via google without any trouble"

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
bret@sybase.com  
View profile  
 More options Jul 16 2012, 12:09 pm
Newsgroups: comp.databases.sybase
From: "b...@sybase.com" <b...@sybase.com>
Date: Mon, 16 Jul 2012 09:09:15 -0700 (PDT)
Local: Mon, Jul 16 2012 12:09 pm
Subject: Re: Convert Hijri Date to Gregorian Date
Print | Individual message | Show original | Report this message | Find messages by this author

>Thanx for the reply Bret... Enabling Java is not an option for us...
>can u throw some more light on " I found several
>possible implementations via google without any trouble"

Searching Google for "hijri java gregorian" produced several
hits on sites that appear to be offering Java code for doing the conversion.

Cheers,
-bret


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google