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
srujana thallam
NA
76
138.9k
Convert Date time format
Apr 16 2014 9:35 AM
Hi
I have a Db2 data base in db2 the date and time stored including millisec.I want to get the data from DotNet C#. For comparing I have a data without milli sec.so i want to remove the millisec dta in db and compare .
This is my C# Query.
"SELECT " + "'(TIMESTAMP_FORMAT(StartDate,'YYYY-MM-DD HH24:MI:SS'))'"+ " FROM TableName where " + FirstName+ " = '" + fName + "'";
Can any one guide to get the result without Millisec.
Thanks
Reply
Answers (
2
)
How to show multiple alert message in web application
Database with mutli language data