Categories
SQL Server

Convert Julian Dates in SQL SERVER

  • SQL SERVER JULIAN TO DATE (WHEN DOWNLOADING JULIAN DATE)
  • date field has to be nvarchar or varchar or character.

    • declare @DateP char(10)

    select @datep=107277 — ALSO OK FOR 99 YEARS

    select
    dateadd(dd,@datep-(@datep/1000)*1000-1, convert(datetime,’01/01/’+ right(convert(varchar,@datep/1000),2))) as Date_ENT

    Related posts:

    1. Convert from varchar to decimal Here’s a way to convert a VARCHAR to DECIMAL, wrap...
    2. SQL: YYYYMMDD SELECT CONVERT(VARCHAR(8), GETDATE()-365, 112) This is a way to query...
    3. How To Convert Confusing Ascii Code To A Character CHAR can be used to insert control characters into character...
    4. Uniqueidentifier (T-SQL) UniqueIdentifier is a 16-byte GUID. The uniqueidentifier type is limited...