Viewing 7 posts - 1 through 8 (of 8 total)
This is backend tables are on SQL server where I got access to retrieve data where datatype for POdate is nvarchar(48).
That doesn't explain the data type choice. A...
November 19, 2019 at 4:12 pm
Jeff Moden wrote:What is the actual datatype of the POdate column?
Datatype is nvarchar(48) but when I run Isdate() function it shows 1 which is valid date.
ISDATE() , like it's...
November 19, 2019 at 3:37 pm
What is the actual datatype of the POdate column?
Datatype is nvarchar(48) but when I run Isdate() function it shows 1 which is valid date.
November 19, 2019 at 1:30 pm
This is pseudo-SQL, but seems like you'd be better off with a start and end parameter, which you set at the start of the batch:
DECLARE @StartDate...
November 18, 2019 at 7:14 pm
Should I use declare variable above query or I can use in between as well ?
November 18, 2019 at 5:47 pm
Hi I am trying to get :
if today is Monday then it will show result from Friday to Sunday
Else
if today is not Monday then I will show you result one...
November 18, 2019 at 3:29 pm
Thank you all of you for explaining. If I want to retrieve data from SQL server and Oracle. Is there any difference in query structure between SQL and Oracle or...
November 18, 2019 at 3:08 pm
Viewing 7 posts - 1 through 8 (of 8 total)