KnowledgeBase
a KnowledgeBase blog for my random thoughts and observations...
Wednesday, August 5, 2015
ORACLE SQL BETWEEN two dates
SELECT
*
FROM
ps_job
WHERE
emplid
=
'00000000000'
and
action_dt
between
to_date
(
'10/01/2014'
,
'mm-dd-yyyy'
)
and
to_date
(
'06/30/2015'
,
'mm-dd-yyyy'
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment