SqlDate.cpp File Reference

Go to the source code of this file.

Namespaces
namespace	boost::posix_time
namespace	boost::gregorian
Typedefs
typedef boost::date_time::c_local_adjustor< boost::posix_time::ptime >	local_adj
Functions
int	DateToIsoString (char *dest, boost::posix_time::ptime t)
int	TimeToIsoString (char *dest, boost::posix_time::ptime t)
int	TimestampToIsoString (char *dest, boost::posix_time::ptime t)
static void	trimSpaces (std::string &s)
int64_t	IsoStringToDate (const char *const src, int len)
int64_t	IsoStringToTime (const char *const src, int len)
int64_t	IsoStringToTimestamp (const char *const src, int len)
int64_t	UniversalTime ()
	Returns time of day in UTC.
int64_t	UniversalTimestamp ()
	Returns timestamp in UTC.
int64_t	LocalTime (boost::local_time::time_zone_ptr tzPtr)
	Returns the time of day in the given time zone.
int64_t	LocalTimestamp (boost::local_time::time_zone_ptr tzPtr)
	Returns the timestamp in the given time zone.
Variables
int64_t	milliseconds_per_day = 24 * 60 * 60 * 1000LL

---

Typedef Documentation

typedef boost::date_time::c_local_adjustor<boost::posix_time::ptime> local_adj

Definition at line 45 of file SqlDate.cpp.

---

Function Documentation

int DateToIsoString	(	char *	dest,
		boost::posix_time::ptime	t
	)

Definition at line 47 of file SqlDate.cpp.

Referenced by SqlDateToStr().

{
    int y = t.date().year();
    int m =  t.date().month();
    int dy = t.date().day();
    return snprintf(dest,11, "%4d-%02d-%02d", y,m, dy);
}

int64_t IsoStringToDate	(	const char *const	src,
		int	len
	)

Definition at line 96 of file SqlDate.cpp.

References epoc(), milliseconds_per_day, and trimSpaces().

Referenced by SqlStrToDate(), and SqlDateTest::testSqlStrToDate_Ascii_Helper().

{
    std::string s(src,len);
    trimSpaces(s);

    boost::regex dateExp("\\d+-\\d+-\\d+");
    if (boost::regex_match(s, dateExp)) {
        try {
            date_duration td = boost::gregorian::from_string(s) - epoc.date();
            return td.days() * milliseconds_per_day;
        } catch (...) {
            // Fall through to throw
        }
    }

    // Parse of date failed
    // SQL2003 Part 2 Section 6.12 General Rule 13 data
    // exception -- invalid datetime format
    throw "22007";
}

int64_t IsoStringToTime	(	const char *const	src,
		int	len
	)

Definition at line 117 of file SqlDate.cpp.

References min(), and trimSpaces().

Referenced by SqlStrToDate(), and SqlDateTest::testSqlStrToDate_Ascii_Helper().

{
    std::string s(src, len);
    trimSpaces(s);

    // TODO: Boost library doesn't catch invalid hour, min, sec
    // TODO: Try updated boost library to see if we can get
    // TODO: rid of this tiresome check
    boost::cmatch what;
    boost::regex timeExp("(\\d+):(\\d+):(\\d+)(\\.\\d+)?");
    if (boost::regex_match(s.c_str(), what, timeExp)) {
        try {
            int hour = atoi(what[1].first);
            int min = atoi(what[2].first);
            int sec = atoi(what[3].first);

            if ((hour >= 0) && (hour < 24) &&
                (min >= 0) && (min < 60) &&
                (sec >= 0) && (sec < 60)) {
                time_duration td = duration_from_string(s);
                return td.total_milliseconds();
            }
        } catch (...) {
            // Fall through to throw
        }
    }

    // Parse of time failed
    // SQL2003 Part 2 Section 6.12 General Rule 15,16 data
    // exception -- invalid datetime format
    throw "22007";
}

int64_t IsoStringToTimestamp	(	const char *const	src,
		int	len
	)

Definition at line 150 of file SqlDate.cpp.

References epoc(), min(), and trimSpaces().

Referenced by SqlStrToDate(), and SqlDateTest::testSqlStrToDate_Ascii_Helper().

{
    std::string s(src, len);
    trimSpaces(s);

    // TODO: Boost library doesn't catch invalid hour, min, sec
    // TODO: Try updated boost library to see if we can get
    // TODO: rid of this tiresome check
    boost::cmatch what;
    boost::regex timestampExp("\\d+-\\d+-\\d+ +"
                       "(\\d+):(\\d+):(\\d+)(\\.\\d+)?");
    if (boost::regex_match(s.c_str(), what, timestampExp)) {
        try {
            int hour = atoi(what[1].first);
            int min = atoi(what[2].first);
            int sec = atoi(what[3].first);

            if ((hour >= 0) && (hour < 24) &&
                (min >= 0) && (min < 60) &&
                (sec >= 0) && (sec < 60)) {
                ptime p(time_from_string(s));
                time_duration td = p - epoc;
                return td.total_milliseconds();
            }
        } catch (...) {
            // Fall through to throw
        }
    }

    // Parse of timestamp failed
    // SQL2003 Part 2 Section 6.12 General Rule 17,18 data
    // exception -- invalid datetime format
    throw "22007";
}

int64_t LocalTime

(

boost::local_time::time_zone_ptr

tzPtr

)

Returns the time of day in the given time zone.

Definition at line 203 of file SqlDate.cpp.

{
    local_date_time plocal = local_microsec_clock::local_time(tzPtr);
    return plocal.local_time().time_of_day().total_milliseconds();
}

int64_t LocalTimestamp

(

boost::local_time::time_zone_ptr

tzPtr

)

Returns the timestamp in the given time zone.

Definition at line 209 of file SqlDate.cpp.

{
    // Create a local epoch. For PST, for example, the epoch is 1970/1/1 PST,
    // which occurred 8 hrs after the UTC epoch.
    date d(1970, 1, 1);
    time_duration td(0, 0, 0);
    local_date_time local_epoc(
        d, td, tzPtr, local_date_time::NOT_DATE_TIME_ON_ERROR);

    local_date_time plocal = local_microsec_clock::local_time(tzPtr);
    time_duration diff = plocal - local_epoc;

    // Adjust the difference if we are now in DST and the epoch is not, or vice
    // versa.
    if (plocal.is_dst()) {
        if (local_epoc.is_dst()) {
            // same offset: nothing to do
        } else {
            diff += tzPtr->dst_offset();
        }
    } else {
        if (local_epoc.is_dst()) {
            diff -= tzPtr->dst_offset();
        } else {
            // same offset: nothing to do
        }
    }
    return diff.total_milliseconds();
}

int TimestampToIsoString	(	char *	dest,
		boost::posix_time::ptime	t
	)

Definition at line 65 of file SqlDate.cpp.

References min().

Referenced by SqlDateToStr().

{
    time_duration td = t.time_of_day();
    int h   = td.hours();
    int min = td.minutes();
    int s   = td.seconds();

    int y   = t.date().year();
    int mon = t.date().month();
    int dy  = t.date().day();
    return snprintf(
        dest, 20, "%4d-%02d-%02d %02d:%02d:%02d", y,mon, dy, h, min, s);
}

int TimeToIsoString	(	char *	dest,
		boost::posix_time::ptime	t
	)

Definition at line 56 of file SqlDate.cpp.

Referenced by SqlDateToStr().

{
    time_duration td = t.time_of_day();
    int h = td.hours();
    int m = td.minutes();
    int s = td.seconds();
    return snprintf(dest,9, "%02d:%02d:%02d", h, m, s);
}

static void trimSpaces

(

std::string &

s

)

[inline, static]

Definition at line 83 of file SqlDate.cpp.

Referenced by IsoStringToDate(), IsoStringToTime(), and IsoStringToTimestamp().

{
    std::string::size_type n = s.find_last_not_of(' ');

    if (n == std::string::npos) {
        s.resize(0);
    } else {
        s.resize(n + 1);
        n = s.find_first_not_of(' ');
        s.erase(0, n);
    }
}

int64_t UniversalTime

(

)

Returns time of day in UTC.

(This function used to be called CurrentTime, but as FNL-77 points out, that is misleading, because CurrentTime's result is in the local timezone.)

Definition at line 185 of file SqlDate.cpp.

Referenced by CurrentTime(), and SqlDateTest::testUniversalTime().

{
    ptime p = second_clock::universal_time();
    return p.time_of_day().total_milliseconds();
}

int64_t UniversalTimestamp

(

)

Returns timestamp in UTC.

That is, milliseconds since 1970-1-1 00:00:00 UTC.

(This function used to be called CurrentTimestamp, but as FNL-77 points out, that is misleading, because CurrentTimestamp's result is in the local timezone.)

Definition at line 191 of file SqlDate.cpp.

References epoc().

Referenced by CurrentTimestamp(), and SqlDateTest::testUniversalTime().

{
    // REVIEW: SWZ: 4/30/2006: In practice, we should return the micro
    // second delta (or as much precision as we can muster) and let
    // the instruction (which may have been given an explicit
    // precision) truncate the fractional seconds.  For now, returning
    // millis causes Fennel Calc to behave like the Java Calc for
    // CURRENT_TIME[STAMP].
    ptime p = microsec_clock::universal_time();
    return (p - epoc).total_milliseconds();
}

---

Variable Documentation

int64_t milliseconds_per_day = 24 * 60 * 60 * 1000LL

Definition at line 79 of file SqlDate.cpp.

Referenced by IsoStringToDate().

---