如何使用 Apache Derby 格式化日期？

发布于 2024-08-27 06:04:24 字数 245 浏览 8 评论 0原文

我想很好地格式化从查询中收到的日期，例如：

SELECT recdate FROM myrecords;

实际上，我正在搜索该函数以使用日期模式进行漂亮的格式化，如果像 SimpleDateFormat 这样就更好了。如果不可能，我如何构建一个格式化类与类似的东西：

SELECT MyFormatter(recdate) FROM myrecords

原文

I would like to format nicely a date received from a query like:

SELECT recdate FROM myrecords;

pratically I am searching the function to pretty formatting with a date pattern,
better if SimpleDateFormat like. And if not possible how can I build a class for formatting
with somtehing like:

SELECT MyFormatter(recdate) FROM myrecords

分享到QQ

分享到微博

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

发布评论

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

∞觅青森が 2024-09-03 06:04:24

看这里：

DateFormat 和 SimpleDateFormat 示例

示例代码：

public static void main(String[] args)
{
    // Get the Date object that comes from DerbyDB...
    //Date derbyDate = YOUR DATE FIELD HERE

    // Make a SimpleDateFormat for toString()'s output. This
    // has short (text) date, a space, short (text) month, a space,
    // 2-digit date, a space, hour (0-23), minute, second, a space,
    // short timezone, a final space, and a long year.
    SimpleDateFormat format = new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy");

    // See if we can parse the output of Date.toString()
    try
    {
        Date parsed = format.parse(derbyDate.toString());

        System.out.println(parsed.toString());
    }
    catch(ParseException pe)
    {
        System.out.println("ERROR: Cannot parse \"" + derbyDate.toString() + "\"");
    }
}

Look here:

DateFormat and SimpleDateFormat Examples

Sample code:

public static void main(String[] args)
{
    // Get the Date object that comes from DerbyDB...
    //Date derbyDate = YOUR DATE FIELD HERE

    // Make a SimpleDateFormat for toString()'s output. This
    // has short (text) date, a space, short (text) month, a space,
    // 2-digit date, a space, hour (0-23), minute, second, a space,
    // short timezone, a final space, and a long year.
    SimpleDateFormat format = new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy");

    // See if we can parse the output of Date.toString()
    try
    {
        Date parsed = format.parse(derbyDate.toString());

        System.out.println(parsed.toString());
    }
    catch(ParseException pe)
    {
        System.out.println("ERROR: Cannot parse \"" + derbyDate.toString() + "\"");
    }
}

回复收藏 0 原文

~没有更多了~