通过数据库访问时，需要 eclipse-rcp 中 swt.widgets.DateTime 的时间格式帮助

发布于 2024-11-18 11:20:17 字数 563 浏览 3 评论 0原文

我使用了 DateTime 控件，该控件在我的设计视图中仅以 PM、Am 格式显示时间，并且用户仅从中选择时间。我正在使用列名 timeFrom ，我在 mssql 数据库中删除了 dataType time(7) 。我可以轻松地将其保存到数据库中，假设

objBookingModel.settimeFrom(timeFrom.getHours() + ":"
                + timeFrom.getMinutes() + ":" + timeFrom.getSeconds());

我在设计视图中输入10:54:44 pm，它在数据库中存储为22:54:44。现在，当我想从数据库的设计视图中显示它时，请帮助如何将 22:54:44 格式化为 10:54:44 PM 。我应该使用 timefrom.setTime( ); 吗？

原文

i have use the DateTime control that show only time in my design view in PM, Am format and user select only time from that one. i am using a column name timeFrom which i delcare a dataType time(7) in my mssql database. i can save it easily into the database as

objBookingModel.settimeFrom(timeFrom.getHours() + ":"
                + timeFrom.getMinutes() + ":" + timeFrom.getSeconds());

Suppose i enter 10:54:44 pm in the design view it is stored in the database as 22:54:44. now please Help how to format 22:54:44 as 10:54:44 PM when i want to show back it in design view from the databse. should i have to use timefrom.setTime( );?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

权谋诡计 2024-11-25 11:20:17

Time time; // you have this from your Database query
DateTime dateTime; // you have this already or will create a new one

Calendar calendar = Calendar.getInstance();
calendar.setTimeInMillis(time.getTime());
dateTime.setTime(calendar.get(Calendar.HOUR), calendar.get(Calendar.MINUTE),calendar.get(Calendar.SECOND));

这是我使用过的答案，可能对其他人有帮助......................

Time time; // you have this from your Database query
DateTime dateTime; // you have this already or will create a new one

Calendar calendar = Calendar.getInstance();
calendar.setTimeInMillis(time.getTime());
dateTime.setTime(calendar.get(Calendar.HOUR), calendar.get(Calendar.MINUTE),calendar.get(Calendar.SECOND));

This one was the answer i worked with might be helpful to thers.................

回复收藏 0 原文

~没有更多了~