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 , Delphi 4 C/S
--
Thanks...

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


Fri, 10 May 2002 03: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


Sat, 11 May 2002 03:00:00 GMT
 D4.DB Date 00=1900, 00<>2000
if this is at sql level then take a look at convert and date functions.

Arun


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

Sent via Deja.com http://www.deja.com/
Before you buy.


Sun, 12 May 2002 03:00:00 GMT
 
 [ 3 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