Re: DateTime problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 14:15:29 -0000

Steve,

I thought about that as well, but Hijri is a lunar calendar while the
Persian calendar is a solar calendar not unsimilar (but not too similar
either) to the Gregorian calendar. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Steve Kass" <skass@drew.edu> wrote in message
news:uCK9sdpCEHA.1128@TK2MSFTNGP11.phx.gbl...
> Blue Man,
>
>   Does SQL Server support for the Hijiri (Kuwaiti algorithm) calendar
> help?  This can be used by specifying style 131 when converting datetime
> to and from strings with CONVERT.  Here's an example, though the
> right-to-left issue with Arabic may cause display problems.
>
> select
>   convert(nvarchar(30), getdate(), 130),
>   convert(nvarchar(30), getdate(), 131),
>   convert(datetime, N'11 ???? 1425', 130)
>
> ------------------------------ ------------------------------ 
> ------------------------------------------------------
> 24 ???? 1425  9:08:25:757AM    24/01/1425  9:08:25:757AM      2004-03-02
> 00:00:00.000
>
> SK
>
> Blue Man wrote:
>
> >Hello group
> >the datetime that i use is Persian datetime and its year now is 1380 or
> >something. format doesn't matter something like yyyy-mm-dd but the
problem
> >is Year when ever i try to add data i get "DateTime Field overflow".
> >I checked and realized the date befor year 1800 returns that error. now
what
> >do you suggest me to do with this type of datetime?
> >btw my column is smalldatetime, i also tried datetime but nothing
changed.
> >
> >
> >
> >
>

Relevant Pages

  • Re: UTC conversion from different time zones
    ... but in my idea is the time in Net not real calendar based. ... But if you take something which is already UTC (because you've called ... I find the dateTime pretty good. ... DateTime had no idea whether it was a local time or a universal time - ...
    (microsoft.public.dotnet.general)
  • Re: Improving datetime
    ... Perhaps it might be wise to consider a 'calendar definition object' - I'll dub it a calinfo object for now - that allows third parties to develop a set of rules that define a) how to count in a calendar, and b) how to translate unambiguously from one calendar to another. ... a new 'superaware' datetime object represents a moment in time and would have: ... With time zones, because their offsets regularly swing back and forth, we have issues with illegal and ambiguous local times. ...
    (comp.lang.python)
  • Re: Speed up UDF
    ... Actually a calendar table is pretty simple to use, ... RETURNS datetime ... declare @dtvar as datetime ...
    (comp.databases.ms-sqlserver)
  • Re: Calendar Stuff
    ... import calendar, datetime, time ... def calendarPrint: ...
    (comp.lang.python)
  • Re: converting single record with date range into multiple records
    ... Build a table for the buckets, or use an existing Calendar table: ... (bucket_start DATETIME NOT NULL PRIMARY KEY, ... FROM Parts AS P1, MonthBuckets AS B1 ...
    (microsoft.public.sqlserver.programming)