Member Avatar for jayz_raul

hye there...anyone would let me noe what is the proper data type for display time in sql server 2005??? sumthing it can display 8.00pm-10.00pm...any suggestion? thanks

  • 2 Contributors
  • 1 Reply
  • 41 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Hamrick
Member Avatar for Hamrick

The datetime data type is what you want, and you can just ignore the date part by always making sure that it's always the same date. Then comparisons will rely on the time.

set @myTime = @myTime - dateadd( dd, 0, datediff( dd, 0, @myTime ) )

In VB.NET you do the same thing with the DateTime data type.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.