Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hafidz
Starting Member
11 Posts |
 Posted - 2007-08-07 : 05:24:46
|
Hello,How to get the time different in minutes in Firebird SQL??It's something like this but this one obviously cannot execute.. huhua.create_time <= (b.submit_date + 10) //10 minutes??!!and a.create_time >= (b.submit_date - 10) Thanks in advance :-) |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-08-07 : 05:34:12
|
quote:
Firebird SQL??
What is Firebird SQL ?to add 10 minutes in MS SQL Server dateadd(minute, 10, b.submit_date)
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-08-07 : 05:37:51
|
oh this firebird http://www.firebirdsql.org/This is a Microsoft SQL Server forum site. And you have posted in SQL Server 2005 forum. The query i posted will works on MS SQL Server.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
hafidz
Starting Member
11 Posts |
Posted - 2007-08-07 : 05:42:17
|
| Firebird SQL Server..The column is in timestamp format..No "dateadd" function in Firebird :-(Help me please.. |
|
|
|
hafidz
Starting Member
11 Posts |
Posted - 2007-08-07 : 05:44:17
|
quote:
Originally posted by khtan
oh this firebird http://www.firebirdsql.org/This is a Microsoft SQL Server forum site. And you have posted in SQL Server 2005 forum. The query i posted will works on MS SQL Server.
KH[spoiler]Time is always against us[/spoiler]
ohhh... wrong place.. hoho ;-P |
|
|
|
|
|
|
TIMESTAMP DIFFERENT