select cast(floor(cast(getdate()-30 as float)) as datetime)
If you know the actual date string, you can use it simply as follows:
select * from emp where dat between '2012-04-17' and '2012-04-18'
select cast(floor(cast(getdate()-30 as float)) as datetime)
select * from emp where dat between '2012-04-17' and '2012-04-18'
It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here'. Lorem Ipsum has been the industry's standard dummy text ever since.
Lorem Ipsum has been the industry's standard dummy text ever since. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since.
Follow my YouTube channel for more awesome content. For feedback business collaboration you can use the contact form on the right.
0 Comments