Gregorian -> Julian -> Gregorian ?????
Jan 29, 1999
Hello SQL loving citizens,
My question is in regards to the translation of Gregorian dates into Julian dates, and then back.
The easiest thing is to convert gregorian dates into Julian. Just use DATEDIFF(dd, '1/1/1753', getdate()) to get today's date in
gregorian type. However, turning it back , or turning any number in between bach into Gregorian is a feat.
Does anybody have any Idea of how to do this? I am sure I could figure it out eventually, just in case someone has a tool or
a stored procedure already written that does this.
Thank you.
David
View 1 Replies
Mar 3, 2012
how to use SSIS to convert Julian date to Gregorian date. For example, julian 112001 to Gregorian 01/01/2012.
We are currently using SQL 2008 as the database for ERP/JDE tables.
View 13 Replies
View Related
Sep 23, 2015
I am trying to convert Julian Date YYYYDDD format to Gregorian Date.
Able to convert using the SQL Query but not sure how to implement in SSIS.
Script:
SELECT DATEADD(yy,'2011228'/1000-1900,'2011228'-('2011228'/1000*1000)-1) AS [Date]
Let me know how to convert this function into SSIS.
View 2 Replies
View Related
Feb 25, 2005
hello,
I want to convert a gregorian date in mm/dd/yyyy format in MS SQL 2000.
:)
View 1 Replies
View Related
Jun 30, 2004
I have a julian date(04159) and I need to convert this to any normal date format yyyymmdd or mmddyy or basically anything that I can work with! I am just about fed up with trying to convert this. It would be simple enough if there want leap years. Does anyone have a function or something out there that can convert this for me? Code that I found on the web turned out to be bogus. Your help will be greatly appreciated. If you have something in VB that would work also. SQLServer preferably.
Thanks
View 4 Replies
View Related
Jun 2, 2004
A table that I am querying from has the date field in julian date format "04194". I am only wanting to pull the information from this table that is => than todays date. Maybe some of you have done this before and can give a little help in finding the best way to do this?
View 7 Replies
View Related
May 4, 1999
I looked through BOL and could not find a Julian date style. Is there one that I did
not stumble across? Where to find -
View 1 Replies
View Related
Jul 10, 2001
Does SQL Server 7.0 + support Julian date format. If so,
what is the name of the function used to retrieve it?
Thanks,
-B
View 1 Replies
View Related
Sep 12, 2005
Can anyone tell me how to convert julian date time to DateTime and Vice Versa?the function which I have only convers the date to Julian and julian to date but the time is not appended. How can i get the time into Julian format and from julian format?Any help would be appreciated.thanks.
View 2 Replies
View Related
Jan 3, 2000
Does anyone have Julian date conversion functions? To, or From?
ie. I get 99002 and want to convert to "1999/01/02"
or vise-versa.
Thanks in advance,
Dano
View 2 Replies
View Related
May 9, 2008
Im working on a project to convert a C program from OCI(oracle) to ODBC(MsSQL).
One of the select statements uses oracle julian time:
"Select TO_NUMBER(TO_CHAR(TO_DATE('0101'||:styear,'mmddyyyy'),'J')) STYEAR from dual"
Its not a problem converting the statement, except msSQL uses 10/01/1900 as its origin for the julain calendar, where Oracle uses somewhere around 5000BC. my questions is, because this program is made to use oracle julian and need to keep it that way, how i can make the SQL conversion using oracles origin date?
View 13 Replies
View Related
Oct 24, 2003
Hi,
I have julian date in the format of 2003182 and I need to convert into our regular calendar date.
Anybody have any SQL statement for this.
Thanks,
Ravi
View 2 Replies
View Related
Nov 11, 2002
Hello,
anybody has query regarding converting date from Julian into our our dateformat?.
Your Help really apreciated,
Thanks,
Ravi
View 3 Replies
View Related
Jun 13, 2002
In SQL Server 2000:
How do I convert a Julian date to a Gregorian date?
How do I convert a Gregorian date to Julian?
Examples please.
Many thanks in advance.
Gary Andrews
View 2 Replies
View Related
