MaxLength and dates

From: Javier Crespo <javier.crespo_at_altana.es>
Date: Tue, 2 Oct 2001 10:41:34 +0200
Message-ID: <9pbtqr$k8s$1@talia.mad.ttd.net>

Hi!

I need to know some data of these databases: Oracle, Sybase, DB2, Informix, SqlServer.

-> MaxLength of Table name:

-> MaxLength of Column name:

-> MaxLength of Alias name (t1.id AS userId):

-> how i can specify:

      select * from t where date='2001-02-10';     but not afected by locale.

     (in Oracle I use:
      select * from t where date=to_date('2001/02/10','YYYY/MM/DD');
      I prefer specify the format rather than rely in an standard
     )



 -> how i can specify:

      select * from t where name='cote d'or';

    but not afected by locale (i dont know if locale is aplicable for that).     (in Oracle I use:
     select * from t where name='cote d'||chr(39)||'or';     )

thanks

javi.

pd.- please specify in your reply what database you are you talking about ;-) Received on Tue Oct 02 2001 - 03:41:34 CDT