neuralib.sqlp.func_date

SQL functions related to datetime.

https://www.sqlite.org/lang_datefunc.html

neuralib.sqlp.func_date.date(t, *m)[source]

https://www.sqlite.org/lang_datefunc.html

Parameters:
  • t – time value

  • m – modifier

Returns:

Return type:

SqlExpr

neuralib.sqlp.func_date.time(t, *m)[source]

https://www.sqlite.org/lang_datefunc.html

Parameters:
  • t – time value

  • m – modifier

Returns:

Return type:

SqlExpr

neuralib.sqlp.func_date.datetime(t, *m)[source]

https://www.sqlite.org/lang_datefunc.html

Parameters:
  • t – time value

  • m – modifier

Returns:

Return type:

SqlExpr

neuralib.sqlp.func_date.julianday(t, *m)[source]

https://www.sqlite.org/lang_datefunc.html

Parameters:
  • t – time value

  • m – modifier

Returns:

Return type:

SqlExpr

neuralib.sqlp.func_date.unixepoch(t, *m)[source]

https://www.sqlite.org/lang_datefunc.html

Parameters:
  • t – time value

  • m – modifier

Returns:

Return type:

SqlExpr

neuralib.sqlp.func_date.strftime(fmt, t, *m)[source]

https://www.sqlite.org/lang_datefunc.html

Parameters:
  • fmt (LiteralString) – format

  • t – time value

  • m – modifier

Returns:

Return type:

SqlExpr

neuralib.sqlp.func_date.timediff(a, b)[source]

https://www.sqlite.org/lang_datefunc.html

Parameters:
  • a – time value

  • b – time value

Returns:

Return type:

SqlExpr