|
|
|
Дата
|
|||
|---|---|---|---|
|
#18+
Hi, как узнать вчерашнюю дату? Ничего похожего на sysdate я не нашел. Заранее спасибо. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2003, 22:35:52 |
|
||
|
Дата
|
|||
|---|---|---|---|
|
#18+
Oracle date arithmetic uses day as a unit. For example, SYSDATE - 1 is exactly same time yesterday, SYSDATE + 1/24 is one hour from now. So TO_CHAR(SYSDATE - 1, 'DD/MM/YYYY') is what you are looking for. SY. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2003, 22:42:43 |
|
||
|
Дата
|
|||
|---|---|---|---|
|
#18+
yes it is thank you very much. P.S. It's wierd that you are answering in english :) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.06.2003, 01:49:58 |
|
||
|
Дата
|
|||
|---|---|---|---|
|
#18+
>It's wierd that you are answering in english :) I live in the US and often connect to this forum from work. Even though my boss is OK and he does not mind me browsing Russian sites, I do not want to test his reaction to Russian keybord in my office. I tried virtual keybord but it goes so slow - clicking each letter. So I figured programmers should be able to read in English anyway. SY ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.06.2003, 02:59:10 |
|
||
|
|
start [/forum/topic.php?fid=52&msg=32192167&tid=1989801]: |
0ms |
get settings: |
7ms |
get forum list: |
12ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
269ms |
get topic data: |
7ms |
get forum data: |
2ms |
get page messages: |
29ms |
get tp. blocked users: |
1ms |
| others: | 203ms |
| total: | 536ms |
| 0 / 0 |
