judithSampathwa
-2
Posting Pro in Training
Recommended Answers
Jump to PostHere's a code snippet to demonstrate the functions you will need:
declare @myDate datetime set @myDate = '1/1/2001' select @myDate as StartDate, getdate() as today, DATEDIFF(YEAR, @myDate, GETDATE()) as years
Just replace the datetime variable with your column name in a "select" from the table you need, …
All 3 Replies
BitBlt
452
Practically a Master Poster
Featured Poster
judithSampathwa
-2
Posting Pro in Training
judithSampathwa
-2
Posting Pro in Training
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.