If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Enable date and time data types

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.

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.