Browse by Tags

I need to convert a julian date(YYYYDDD) to MMDDYY using WRKQRY

I have a file that has records that only contain dates in julian format. (i.e. 2006082). Can you, using Query, create a result field for the julian date and have it contain the MMDDYY equivalent of the julian date? 2006082 would be converted to 032306 OS/400 release V4R3M0 Thanks, Phil

Posted to System Programming (Forum) by microsoft on 04-30-2010
Julian Date Conversion

Looking for a function to convert a julian date field (YYDDD or YYYYDDD) into gregorian (MM/DD/YY or MM/DD/YYYY)

Posted to Access (Forum) by microsoft on 11-09-2009
Julian Date Code?

I need the code to diplay the Julian Date (The number of that day of the year). Eaxmple 1 - Today's Date = 9 Jan, 2001 Today's Julian Date = 009 (indicating the 9th day of the year) -------------------------------------------------------- Example 2 - Today's Date = 10 Sep, 2001 Today's...

Posted to Access (Forum) by microsoft on 07-19-2009
T-SQL Convert Julian Date to Standard Date Format

Hello, Could someone tell me how what the syntax is to convert a Julian date to a regular date format in SQL? Thanks. d-

Posted to MS SQL Server (Forum) by microsoft on 07-13-2009
Julian Date (yyddd) conversion using T-SQL or UDF

I am wanting to convert a Julian Date (format: yyddd) to a standard column defined as datetime in T-SQL or User Defined Function.

Posted to MS SQL Server (Forum) by microsoft on 06-14-2009
Problem: How to convert a julian date to DateTime in C++ .Net

Hi, If I have a number 242424 which is Julian day, how to convert it to DateTime in C++ .Net? Thanks, Jennifer

Posted to Visual C++ (Forum) by microsoft on 06-07-2009
Problem: T-SQL Date to Julian Conversion

Using T-SQL how can a date field (mm/dd/yyyy) be converted to a Julian Day Number?

Posted to MS SQL Server (Forum) by microsoft on 06-05-2009
Problem: SQL Julian date conversion without time

I am need to know how to convert a Julian date (101335 = 12/01/2001) without time included. Below is the code that I am currently using but the output has a time stamp on it as well. I also need to be able to put this in select statement because I am pulling alot of other data with this. F1501B.NEEFTE...

Posted to MS SQL Server (Forum) by microsoft on 06-03-2009
Problem: Custom Julian Date Conversion

Does anyone have a stored procedure that coverts 6 digit long julian dates to standard dates? Example: 95001 = 01/01/1995 100001 = 01/01/2000 105031 = 01/31/2005 Or how could I do this in a DTS script?

Posted to MS SQL Server (Forum) by microsoft on 05-30-2009
Problem: Julian Date Coversion

I am using SQL server 2000 with data from as/400 dts transfer. I have a date field with julian dates that look like this: 101087 Any idea how to convert this date to regular date in display in frontpage created databse wizard results. I have tried to tweek SQL drive in odbc admin. no luck as of yet.

Posted to FrontPage (Forum) by microsoft on 05-27-2009

Page 1 of 1 (10 items)