D4.DB Date 00=1900, 00<>2000 
Author Message
 D4.DB Date 00=1900, 00<>2000
When I input date in dbGrid, for example 1.1.00
then I take the full date 1.1.1900

How to make 2000 from 00 automatically?
Please give some examples.

My DB is SQL Anywhere 5.5

--
Thanks...

http://www.***.com/ - home



Wed, 18 Jun 1902 08:00:00 GMT
 D4.DB Date 00=1900, 00<>2000

When I input date in dbGrid, for example 1.1.00
then I take the full date 1.1.1900
-
How to make 2000 from 00 automatically?
-
Please give some examples.
-
My DB is SQL Anywhere 5.5 , Delphi 4 C/S
--
Thanks...

http://klokov.conk.com - home


Wed, 18 Jun 1902 08:00:00 GMT
 D4.DB Date 00=1900, 00<>2000
What version of Delphi are you using?
D4 has a built-in century window to allow two digit years to be
entered and automatically expanded to the correct century. D2 didn't,
and I don't know about D3.

Dan

On Mon, 22 Nov 1999 14:08:55 +0300, " Sergiy Klokov"

Quote:

>When I input date in dbGrid, for example 1.1.00
>then I take the full date 1.1.1900
>-
>How to make 2000 from 00 automatically?
>-
>Please give some examples.
>-
>My DB is SQL Anywhere 5.5 , Delphi 4 C/S
>--
>Thanks...

>http://klokov.conk.com - home

--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control: Consulting, Software,
and the only comprehesive textbook on this subject.
visit us at www.cmdcsystems.com
[Remove the SPAM from my e-mail address]


Wed, 18 Jun 1902 08:00:00 GMT
 D4.DB Date 00=1900, 00<>2000

Quote:

> When I input date in dbGrid, for example 1.1.00
> then I take the full date 1.1.1900
> -
> How to make 2000 from 00 automatically?
> -
> Please give some examples.
> -
> My DB is SQL Anywhere 5.5 , Delphi 4 C/S
> --

it's not Delphi problem.

MS SQL decide problem ->
   if YearOfDate > 50 then it's 19xx year
     else it's 20xx year

you must find fix for SQL Anywhere...



Wed, 18 Jun 1902 08:00:00 GMT
 D4.DB Date 00=1900, 00<>2000
Quote:
>MS SQL decide problem ->
>   if YearOfDate > 50 then it's 19xx year
>     else it's 20xx year
>you must find fix for SQL Anywhere...

-
You are right of course.
But I must write this procedure for all fields
in MS SQl, am I right?
-
Quote:
>it's not Delphi problem.

-
I found this answer: (thanks to Dan Brennand)
-
procedure TForm1.FormCreate(Sender: TObject);
begin
     TwoDigitYearCenturyWindow:=50;
end;
-
Thanks...
********************************************* >:-)
Sergiy Y. Klokov

(+38 044) 419-87-68 - work phone/fax, 263 - Inner phone (2-35 in foyer)

http://klokov.conk.com/   - home page for all
ICQ: 52326200
********************************************* >:-)


Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. D4.DB Date 00=1900, 00<>2000

2. 00 date returns 1900 instead of 2000 in a select statement

3. how do i get only the date format from 2001-01-01 00:00:00.000

4. Help with 00:00:00:00 format

5. Bad Timestamp Format at 19 in 1974-08-02 00:00:00.00+01] in PostgresQL

6. WHY? last_batch = '01 Jan 1900 00:00:00:000'

7. Time 00 . Date 00

8. Invalid dates (00.00.0000) inserted with Oracle8.04 (ODBC 8.05)

9. An Oracle Date bug: 00-00-0000 ?

10. date is displaying 00.00.000 when initialized !

11. Parameterized Queries in DTS using SYBASE 11 Driver Version 3.01.00.00

12. Problems after Upgrade 4.00.3711.08 to 4.00.5303.01


 
Powered by phpBB® Forum Software