Re: Awkward SQL

[Paul Hastings]

> SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE)
> FROM table

or if you're not fortunate enough to have standards compliant db like
postgres,  say sql server:

SELECT CAST(CONVERT(char(12),DATEADD(minute,541,yourDateColumn),101) AS
smalldatetime) AS yourNewDateTime

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---