Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    3

    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.

    Héctor

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    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?
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Apr 2011
    Posts
    3
    Thanks for your reply.

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

    Héctor
    Attached Files Attached Files

  4. #4
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    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.
    I'm not crazy, I'm an aeroplane!

  5. #5
    Join Date
    Apr 2011
    Posts
    3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •