Good afternoon.

We need to use the time and date types added in ASE 12.5.1 in a existent database schema. Below the results of querying systypes in master and finance (the schema in which we need the additional data types)

use master
go

select name from systypes where name in ('time','date')

use finance
go

select name from systypes where name in ('time','date')


name
------------------------------
date
time

(2 row(s) affected)

name
------------------------------

(0 row(s) affected)

What can we do in order to enable the date and time data types in my finance schema?. Thanks in advance.

Héctor

The standard datatypes in master..systypes should be available in every database in the instance. The finance..systypes table can hold additional userdefined datatypes.

What result does select * from fincance..systypes give?

Thanks for your reply.

The result of executing select * from finance..systypes is attached.

Héctor

Ah, this is interesting. I checked in my own ASE12.5.1-server, and I get the very same results. To be honest, I don't know how or why this is, and no idea where the date and time datatypes come from.
You could use theexisting datetime-datatype in your userdb, and use a datetime-convert, or trim to extract the desired part of the datetimevalue.

Well... an application was developed in an environment with date and time data types available, so we will need to modify the source code then in order to use it in the new environment without them. Anyway... thank you very much for your help.

Best regards...

Héctor