TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
djohncon
NA
16
0
convert date/time in database code
Feb 25 2005 3:04 PM
Hi all, I have a combo box that is populated by a table of date/time. I have a Ms Access Database and i have OleDBadaptor with a sql statement SELECT date from date1. This populates the ComboBox with a date/time data but i would like to filter out the time. Does anyone know how to do this within the sql statement. I tried an oracle sql statement select to_char(Date, 'ddmmyyyy') from Date1 it does not work. I also used a transact sql statement select "date" = convert(char(15),date,110) from Date1 and that does not work. Is the sql that is used in C# Transact Sql or some other fragment of sql. thanks kamean
Reply
Answers (
3
)
Passing Field Values to a text box
Master Pages