SQL Server 2008 Converting bind DataField form

forum.td.development (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

SQL Server 2008 Converting bind DataField form

Post by NewsgroupServer » 11 Jun 2010, 17:01

 Posted by:  Henrique 

Hy,

I need to change the mask of a DataField return of "yyyy-MM-dd-hh: mm: ss"
to "yyyy-MM-dd hh: mm: ss" datetime type in SQL Server 2008, if I convert
the date in text You can write to SQL, but if you mean the DataField in
direct SQL command returns data conversion error.

Data Field: dfDateExp
Date Type: Date/Time
Format: dd/MM/yyyy hh:mm:ss
Imput Mask: 99/99/9999 99:99:99
...
Information
25/01/2010 10:38:07

Action
"Update SysAdm.FirmGroup Set DateExp = :frm1.dfDateExp"

Return
2010-01-25-10:38:07

we need a solution for that.

Return
2010-01-25 10:38:07

Temporary Solution
"Update SysAdm.FirmGroup Set DateExp = '2010-01-25 10:38:07' "

Thank you.

Return to “td.development”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests