arcusfelis.github.com

ODBC, MS SQL Server and Erlang

Date and time

1
2
odbc:sql_query(S, "SELECT  {fn CURDATE()}").
{selected,[[]],[{"2012-10-02"}]}
1
2
odbc:sql_query(S, "SELECT  getdate()").
{selected,[[]],[{ { {2012,10,23},{2,6,37} } }]}

{ {2012,10,23},{2,6,37} } has a type sql_datetime.