In SQL Server the DateTime format is like:
January 1, 2000
You need an insert statement like:
insert into mytable values (‘January 1, 2000’)
In Tcl try:
set dt 2006-04-25
set fmtDt [clock format [clock scan $dt] -format “‘%B %d, %Y'”]
# Note the returned date already has the single quotes around it
Then just insert the $fmtDt
