Java Time Format toSQLDateTimeFormat(Calendar cal)

Description

create a SQL-friendly datetime string from a Java Calendar

License

Open Source License

Parameter

Parameter	Description
cal	input calendar

Return

a String version of the date that SQL will like

Declaration

public static String toSQLDateTimeFormat(Calendar cal) 

Method Source Code

//package com.java2s;
/*/*w w w. j ava 2 s.c  om*/
 * @(#)TimeUtils.java   0.51 1999/07/14
 *
 * Copyright (c) 2004, Pat Farrell, All rights reserved.
 * based on work Copyright (c) 2000, OneBigCD, Inc.  All rights reserved.
 * Copyright (C) 2011 Patrick Farrell   All Rights reserved.
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License. * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * 
 * It is abstract because all functions are static
 */

import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;

import java.util.TimeZone;

public class Main {
    /** constant for UTC */
    public static final TimeZone utcTZ = TimeZone.getTimeZone("UTC");

    /**
     * create a SQL-friendly datetime string from a Java Calendar
     * @see java.util.Calendar
     * @param cal input calendar
     * @return a String version of the date that SQL will like
     */
    public static String toSQLDateTimeFormat(Calendar cal) {
        if (cal == null)
            return null;
        return toSQLDateTimeFormat(cal.getTime());
    }

    /**
    * create a SQL-friendly datetime string from a Java Date
    * @param dd the java.util.Date
    * @see java.util.Date
    * @return a String version of the date that SQL will like
    */
    public static String toSQLDateTimeFormat(Date dd) {
        if (dd == null)
            return null;
        SimpleDateFormat utcDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        utcDateFormat.setTimeZone(utcTZ);
        return utcDateFormat.format(dd);
    }
}

Related

1. timeFormatDate(Date d)
2. timeFormatNano(long delta)
3. timeFormatter()
4. timestr(String format, long secs)
5. timeToString(String format, Date date)
6. toString(Date time, String format)
7. toString(String format, long time)
8. toString(String format, long time)
9. toStringFormatTime(long time, String format)