sql code for displaying time

Page 1 of 1

1 Replies - 679 Views - Last Post: 16 September 2012 - 11:48 AM

#1 John-Ellis  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 305
  • Joined: 23-March 10

sql code for displaying time

Posted 16 September 2012 - 11:11 AM

Hi All,

I am writing a program to record information from my bike rides. I am using a sql database to save my information. But there is information in time format

What code do I use in my sql query to store information in time format.

I found this on google can anyone confirm if it is correct

Create Table [dbo].[tablename](
[columnname][GetDate] NULL)

Cheers

John
Is This A Good Question/Topic? 0
  • +

Replies To: sql code for displaying time

#2 John-Ellis  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 305
  • Joined: 23-March 10

Re: sql code for displaying time

Posted 16 September 2012 - 11:48 AM

never mind it's sorted.

I just use the data type "time"
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1