Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Function

Status
Not open for further replies.
c4sob

c4sob

IS-IT--Management
Joined
Mar 6, 2001
Messages
10
Location
US
Hi,
Does anyone know how to simulate the lastday function (to select the last day of any specified month) that Oracle has in Sybase?

--Jim
 
Sort by date Sort by votes
You could use the dateadd function to subtract 1 day from the 1st of the next month.

Greg.
 
Upvote 0 Downvote
Thanks Greg,
I'll see if that will work for this particular requirement.

--Jim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

joeb007
  • Locked
  • Question Question
Function: Time stamps for today
Replies
0
Views
475
joeb007
joeb007
kermit01de
  • Locked
  • Question Question
WHERE datefield > Yesterday() ???
Replies
2
Views
534
kermit01de
kermit01de
synesis
  • Locked
  • Question Question
Wrong date displayed when connecting Sybase from ODBC
Replies
0
Views
268
synesis
synesis
pearlofperls
  • Locked
  • Question Question
max date minus 1
Replies
1
Views
226
PDreyer
PDreyer
h3lpm3
  • Locked
  • Question Question
Adding 7 days to a date
Replies
1
Views
241
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top