Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    4

    Unanswered: Sybase timestamp ??

    Hi all ,
    I have a linked server from SQL to sybase.
    I can see and query all the views on sybase db from within Visual studio..I am trying to query based on todays date.

    Every view in sybase has a column called timestamp of datatype smalldatetime.When I look at the data in this column all rows say Timestamp and don't display any form of date or time.
    I therefore cannot qury this table based on getdate()

    Does anyine know how I use this Timestamp column for my queries ?
    Ray..

  2. #2
    Join Date
    Feb 2007
    Location
    India
    Posts
    56

    RE: Sybase timestamp

    Hi,
    Please note that timestamp is different from date/time data types. timestamp will generate by sybase server.

    Naveen.
    Regards,
    Naveen.
    Sybase DBA-Consultant

Posting Permissions

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