Time Entry

Results 1 to 2 of 2

Thread: Time Entry

  1. #1
    Jojn Guest

    Default Time Entry

    When I enter a time (9:00 retrieved from my asp) into a field in my SQL Server7 table (field format: datetime) the entry reads as 1/1/1900 9:00:00 AM. I&#039;ve just started using SQL Server7(was using Access97) and I was wondering if there is some way that I can put just the time into the field as I have an appropriate date field set up in the table already.<BR>Thank You.

  2. #2
    Join Date
    Dec 1969

    Default RE: Time Entry

    How did you do it in Access? - Isn&#039;t the data type a DATETIME as well?<BR>So, you could just format the output to show Times (HH:MM:SS)

Posting Permissions

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