fix(spanner/spansql): fix invalid timestamp literal formats (#6077)
Co-authored-by: rahul2393 <rahulyadavsep92@gmail.com>
diff --git a/spanner/spansql/parser.go b/spanner/spansql/parser.go
index 176e8a4..0ebefb1 100644
--- a/spanner/spansql/parser.go
+++ b/spanner/spansql/parser.go
@@ -3113,8 +3113,8 @@
"2006-01-02",
"2006-01-02 15:04:05",
"2006-01-02 15:04:05.000000",
- "2006-01-02 15:04:05 -07:00",
- "2006-01-02 15:04:05.000000 -07:00",
+ "2006-01-02 15:04:05-07:00",
+ "2006-01-02 15:04:05.000000-07:00",
}
var defaultLocation = func() *time.Location {
diff --git a/spanner/spansql/sql.go b/spanner/spansql/sql.go
index b82b992..406b5a8 100644
--- a/spanner/spansql/sql.go
+++ b/spanner/spansql/sql.go
@@ -736,7 +736,7 @@
func (tl TimestampLiteral) SQL() string { return buildSQL(tl) }
func (tl TimestampLiteral) addSQL(sb *strings.Builder) {
- fmt.Fprintf(sb, "TIMESTAMP '%s'", time.Time(tl).Format("2006-01-02 15:04:05.000000 -07:00"))
+ fmt.Fprintf(sb, "TIMESTAMP '%s'", time.Time(tl).Format("2006-01-02 15:04:05.000000-07:00"))
}
func (jl JSONLiteral) SQL() string { return buildSQL(jl) }
diff --git a/spanner/spansql/sql_test.go b/spanner/spansql/sql_test.go
index fb7a85a..45f7685 100644
--- a/spanner/spansql/sql_test.go
+++ b/spanner/spansql/sql_test.go
@@ -556,7 +556,7 @@
},
{
TimestampLiteral(time.Date(2014, time.September, 27, 12, 34, 56, 123456e3, latz)),
- `TIMESTAMP '2014-09-27 12:34:56.123456 -07:00'`,
+ `TIMESTAMP '2014-09-27 12:34:56.123456-07:00'`,
reparseExpr,
},
{
