Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Reply
how to get this in access 2007 as a query
radhika ganta
14 years ago
2k
Reply
DECLARE @Date int
SET @Date =DAY(getdate())
--SELECT DateAsInteger = CAST (CONVERT(varchar,@Date,112) as INT)
SELECT DateAsInteger =cast(convert(nvarchar,@Date,112)as int)
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
DataSet
how to get multiple records byusing subqueries in access database 2007