You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by ernst leonhard <el...@secure-net.de> on 2001/03/27 11:52:24 UTC
Torque: DATETIME
Hi all,
what is the recommended Torque type which we should be using for the
DATETIME data type ?
Using DATE we have only the Date without Time, using TIME we have only
the Time. TIMSTAMP is not proper because of its side-effects.
We are now using MySql, but we soon will swith to Oracle.
Thanks,
--
Ernst Leonhard
mailto:el@secure-net.de
_______________________________________________________________
SecureNet GmbH
Intranet und Internet Solutions Tel: +49 89/32133-654
Frankfurter Ring 193a Fax: +49 89/32133-699
80807 München, Germany http://www.secure-net.de
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Torque: DATETIME
Posted by "Albrecht F.Leiprecht" <al...@mail.ccc-casino.com>.
> The Driver that I modified to run with Adabas does behave the same...
I'm starting to dig deeper into Adabas to make a driver who is worth to
be called by that name...
BTW: I got managed to connect to Adabas in Oracle mode. Adabas has
direct support of several modi
Adabas -> basically ANSI
MS Access -> I've been told that SAG is now owned by the
Redmonders
that explains this here at least
Oracle/SQL-PL -> That's amazing. It feels and behaves like a Oracle
DB-Server
The 10 Connect Personal Edition comes with
Suse Linux.
We used it with our own SQLQueue in the
past. It's a good
starter...
Whoever did the coding for the other Drivers there are some Limitations in
Adabas
(i.e. TableNames =< 18). I would like to hear/see/share information with
you. What
ever piece of Information helped you... let me know...
What TestPatterns did you use...
How did you handle incompatibilities...
.
.
.
so
long
albi
btw: should I start posting these msgs in the dev-list ?
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Torque: DATETIME
Posted by "Albrecht F.Leiprecht" <al...@mail.ccc-casino.com>.
> ernst leonhard <el...@secure-net.de> writes:
>
> > > ernst leonhard <el...@secure-net.de> writes:
> > >
> > > > what is the recommended Torque type which we should be using for the
> > > > DATETIME data type ?
> > > > Using DATE we have only the Date without Time, using TIME we have
only
> > > > the Time. TIMSTAMP is not proper because of its side-effects.
> > > > We are now using MySql, but we soon will swith to Oracle.
>
> Use of the JDBC DATE type should now support DATETIME with my MySQL
> out of the box (using the latest from CVS).
The Driver that I modified to run with Adabas does behave the same...
With the introduction of the DateKey, i got Problems with the DATE field.
Do you have an idea ?
I solved the problem using a 8 Digit Decmial (NumberKey yyyymmdd) ...
It makes me angry not to understand why something doesn't work, although
it works fine with mysql :)
so
long
albi
PS: Your name sounds german... are you ... I'm german too, living abroad...
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Torque: DATETIME
Posted by Daniel Rall <dl...@collab.net>.
ernst leonhard <el...@secure-net.de> writes:
> > ernst leonhard <el...@secure-net.de> writes:
> >
> > > what is the recommended Torque type which we should be using for the
> > > DATETIME data type ?
> > > Using DATE we have only the Date without Time, using TIME we have only
> > > the Time. TIMSTAMP is not proper because of its side-effects.
> > > We are now using MySql, but we soon will swith to Oracle.
Use of the JDBC DATE type should now support DATETIME with my MySQL
out of the box (using the latest from CVS).
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Torque: DATETIME
Posted by ernst leonhard <el...@secure-net.de>.
For example 'old_phone_numbers'
+---------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+---------------------+---------------+------+-----+---------+----------------+
| id | int(11) | | PRI | 0 |
auto_increment |
| phone_no | varchar(100) | YES | | NULL
| |
| phone_no_valid_from | timestamp(14) | YES | | NULL
| |
| phone_no_valid_to | timestamp(14) | YES | | NULL
| |
| ews_id | int(11) | | | 0
| |
+---------------------+---------------+------+-----+---------+----------------+
Daniel Rall wrote:
>
> ernst leonhard <el...@secure-net.de> writes:
>
> > Hi all,
> >
> > what is the recommended Torque type which we should be using for the
> > DATETIME data type ?
> > Using DATE we have only the Date without Time, using TIME we have only
> > the Time. TIMSTAMP is not proper because of its side-effects.
> > We are now using MySql, but we soon will swith to Oracle.
>
> Hi Ernst!
>
> Please run `mysql [options] [dbname]` and execute the statement
> `describe [table name];`...I'll look into this if you send the output.
> --
>
> Daniel
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
Ernst Leonhard
mailto:el@secure-net.de
_______________________________________________________________
SecureNet GmbH
Intranet und Internet Solutions Tel: +49 89/32133-654
Frankfurter Ring 193a Fax: +49 89/32133-699
80807 München, Germany http://www.secure-net.de
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Torque: DATETIME
Posted by Daniel Rall <dl...@collab.net>.
ernst leonhard <el...@secure-net.de> writes:
> Hi all,
>
> what is the recommended Torque type which we should be using for the
> DATETIME data type ?
> Using DATE we have only the Date without Time, using TIME we have only
> the Time. TIMSTAMP is not proper because of its side-effects.
> We are now using MySql, but we soon will swith to Oracle.
Hi Ernst!
Please run `mysql [options] [dbname]` and execute the statement
`describe [table name];`...I'll look into this if you send the output.
--
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org