Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Error while running in Maximo where clause
January 15, 2019
8:51 am
Avatar
aligahk06
Member
Members
Forum Posts: 4
Member Since:
January 28, 2018
sp_UserOfflineSmall Offline

Dear Sir,

The following query throw an error while running in where clause, DB is sqlserver 12.0

SELECT
*
FROM
workorder
WHERE
workorder.targstartdate BETWEEN DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0) AND DATEADD (dd, -1, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) + 1, 0))

 

Thanks...

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

Maximofresher: 44

cgregory: 42

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 13553

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1527

Posts: 4194

Newest Members:

Inez Wessel, Rob Kelpe, govindarao kottakotla, Tịnh Phan, Rica Paeste, Monroe Sawyer

Administrators: Chon: 1090, kristensibilia: 0, Joe Grassia: 0