def get_today(as_str=False): now = get_now() today = datetime.datetime(now.year, now.month, now.day) if as_str: return dt.format(today) return today
def test_format(): actual = format(datetime(2008, 1, 15)) assert actual == '20080115'
""" from datetime import datetime import numpy as np import traceback from numpy import NaN from pandas.core.datetools import format, to_datetime from pandas.core.panel import pivot from pandas.core.api import (DataFrame, DataMatrix, Series, Index, isnull) #------------------------------------------------------------------------------- # Query formatting _formatters = { datetime: lambda dt: "'%s'" % format(dt), str: lambda x: "'%s'" % x, np.str_: lambda x: "'%s'" % x, unicode: lambda x: "'%s'" % x, float: lambda x: "%.8f" % x, int: lambda x: "%s" % x, type(None): lambda x: "NULL", np.float64: lambda x: "%.8f" % x, bool: lambda x: "'%s'" % x, } def format_query(sql, *args): """ """
from datetime import datetime import numpy as np import traceback from numpy import NaN from pandas.core.datetools import format, to_datetime from pandas.core.panel import pivot from pandas.core.api import (DataFrame, DataMatrix, Series, Index, isnull) #------------------------------------------------------------------------------- # Query formatting _formatters = { datetime : lambda dt: "'%s'" % format(dt), str : lambda x: "'%s'" % x, np.str_ : lambda x: "'%s'" % x, unicode : lambda x: "'%s'" % x, float : lambda x: "%.8f" % x, int : lambda x: "%s" % x, type(None) : lambda x: "NULL", np.float64 : lambda x: "%.8f" % x, bool : lambda x: "'%s'" % x, } def format_query(sql, *args): """ """ processed_args = []
def format_date(date): f = dt.format(date) return '{}-{}-{}'.format(f[:4], f[4:6], f[6:])
def get_now(as_str=False): now = datetime.datetime.now() if as_str: return dt.format(now) return now