converting date in sql server 2005

views:

answers:

+2 Q:

converting date in sql server 2005

In my application (asp.net) I am uploading the video and storing the video in database like videoname,videotitle,dateofuploded these are the fields. My problem is when I am displaying that video I want to display the date like '2 days ago' or ' one month ago' or 'one year ago'

How can I write the function for converting the date into that process.

Take example of youtube. On that site below the video display the date when it was uploaded.

Can I get that format of date if yes how can I write that.

Thank you

I don't know any built-in SQL functions that can do this, so i think you'll have to write some code for that.

See timespan-to-friendly-string-library-c for a C# example on how to do this.

Am 2010-02-07 10:23:11

ya Mr. Am i referred that link is it c# code or sql command

Surya sasidhar 2010-02-07 10:34:01

ok it is C# code

Surya sasidhar 2010-02-07 10:37:17

can we write in sql

Surya sasidhar 2010-02-07 10:37:48

you better of doing it in the application. SQL isn't the native place for such transformations. If you do want to do it in SQL, you will to write a function (stored procedure) that will do the conversion.

Am 2010-02-07 12:03:08

ya Mr. Am i understood

Surya sasidhar 2010-02-07 12:08:48

+2 A:

The database is probably not the best side of the fence on which to do this. Because it's purely for visual purposes, it belongs in the UI layer of the application code.

Because the range of values (days, weeks, months, years) is finite, it doesn't have to be anything fancy, just a big if statement.

Quick Joe Smith 2010-02-07 10:37:34

ok Thank your Mr. Quick Joe Smith for response i will do on C#

Surya sasidhar 2010-02-07 10:41:54

ansaurus

tags:

views:

answers:

converting date in sql server 2005

related questions