Home Forums SQL Server 2005 T-SQL (SS2K5) Convert GETDATE() to NUMBER RE: Convert GETDATE() to NUMBER

  • December 21, 2009 at 11:26 am

    #1094962

    that is exactly why you'd want to not store a date as a number: 20091221 you can kind of read as a date, but what if the value is 20091250 20099999??

    you are using a number and assuming that certain pairs of digits should not exceed #allowed days/#allowed months. it is bad practice. always store dates as dates.

    at some point you'll be back saying how do i convert 20091221 into a datetime.

    anyway, yo can get the value you want as part of a convert statement:

    SELECT CONVERT(VARCHAR(35),@date,112)

    --results = '20091221'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!