Isthere any function in T-SQL to get day of week using?

Question

Post reply

Isthere any function in T-SQL to get day of week using?

kpao

SSC-Addicted

Points: 406
More actions
April 1, 2006 at 4:26 am

#112464

I've found that there is a function called "trftime" in Sqlite. However, I cannot find any function like this in T-SQL. Is there any function to do this?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246959 More actions · Answer 1

Like this? I don't know SQLLite.

select datepart(dw, getdate())

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

sushila SSC-Dedicated Points: 35293 More actions · Answer 2

Unless you're looking for..

datename(dw, getdate())..?!?!

Since the datepart is dependent on the current setting of "datefirst"...check that first if that's the one you want..

**ASCII stupid question, get a stupid ANSI !!!**

ulfemsoy Grasshopper Points: 21 More actions · Answer 3

If you only want to get the day index, you should check the following description:

MS SQL: Day of Week

avistyx SSC Journeyman Points: 95 More actions · Answer 4

perhaps use convert e.g. convert(varchar, xdate,101)

Uripedes Pants Hall of Fame Points: 3701 More actions · Answer 5

don't know sqlite... it would be helpful if you describe what the function does and give an example.

SQLCurious SSCrazy Points: 2339 More actions · Answer 6

Were you able to find an equivalent function in SQL?

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 7

kpao (4/1/2006)
I've found that there is a function called "trftime" in Sqlite. However, I cannot find any function like this in T-SQL. Is there any function to do this?

You really do need to tell us what that does. Are you looking for a numeric day of the week, a 3 letter name of the day of the week, or the full name of the day of the week?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 8

ulfemsoy (10/12/2011)
If you only want to get the day index, you should check the following description:
MS SQL: Day of Week

You don't need a UDF for this...

SELECT (DATEDIFF(dd,'17530101',GETDATE())-1) %7

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 9

BWAA-HAAA!!! I just realized the original question is from 5 years ago and the OP is probably long gone. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)