Results 1 to 22 of 22

Thread: 2 - .

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User bombov's Avatar
    Join Date: Jan:2007
    Location:
    Posts: 260

    2 - .

    1 :

    SQL SERVER , :

    char,varchar text.ext .

    .

    2. :

    :

    -.
    -().
    -.

    , .

    , , .

  2. #2
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    1. . . ntext unicode, varchar(max) ...

    2. . double - . DATEDIFF(...) datetime int, decimal, float. ... double integer - - , " " . : http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

    : . .
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

  3. #3
    Registered User bombov's Avatar
    Join Date: Jan:2007
    Location:
    Posts: 260
    .

    1. , ( , 99.99% , ) , , , , .

    2. , , .
    : . .
    , .

  4. #4
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    1. : http://msdn.microsoft.com/en-us/library/ms187993.aspx . , . . MSSQL , MSSQL 2008 ( MSSQL 2000, 2 - ).

    2. datetime - : http://msdn.microsoft.com/en-us/library/ms187752.aspx


    3. , . :

    ...... ,
    , , ............

    Last edited by DiadoMraz; 8th October 2009 at 23:26.
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

  5. #5
    Registered User bombov's Avatar
    Join Date: Jan:2007
    Location:
    Posts: 260
    .

    .

  6. #6
    Registered User
    Join Date: Jul:2005
    Location: Sofiq
    Posts: 2,798
    unix timestamp. , ( ). range, / 2 DATETIME .

  7. #7
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    Quote Originally Posted by _ShadoW_ View Post
    unix timestamp. , ( ). range, / 2 DATETIME .
    , datetime int timestamp.
    . , .
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  8. #8
    Registered User
    Join Date: Aug:2006
    Location:
    Posts: 4,052
    , *nix

  9. #9
    relative dude Skydive's Avatar
    Join Date: Nov:2002
    Location: /
    Posts: 2,863
    Quote Originally Posted by solar_sea View Post
    , *nix
    ... 19 2038

  10. #10
    . worm4's Avatar
    Join Date: Jul:2005
    Location: Varna
    Posts: 20,295
    Quote Originally Posted by Skydive View Post
    ... 19 2038
    /
    4 . ...

    . ...
    1.1 . ? ...
    "Arbeit macht frei" -
    - . , :..,,--?!
    OgiDogi: , , ..,

  11. #11
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    , datetime .
    , , .
    datetime -> ..
    ... , - foreign keys, .
    , ...
    , , int(11) 0/1 ...
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  12. #12
    ɐ-əpoɔᴉu⋂ ɐ ə anrieff's Avatar
    Join Date: Apr:2004
    Location: Sofia
    Posts: 8,448
    19 2038 DB , - - DB backend-. - - , time_t 4 expansion...

    , ( : 4 )
    , . .
    "640K ught to be enough for anybody" - Bill Gates, 1981
    ::Machine specs::Fract::AGG::::Baileys::blog::YouTube channel

  13. #13
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    unix timestamp datetime ... .
    ''? * *
    - !
    ...

  14. #14
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    - - . datetime . .net-a DateTime TimeSpan . int - , . , .. -

    . , - - .

    int, double *char , . XML .. -
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

  15. #15
    ɐ-əpoɔᴉu⋂ ɐ ə anrieff's Avatar
    Join Date: Apr:2004
    Location: Sofia
    Posts: 8,448
    Quote Originally Posted by DiadoMraz View Post
    XML .. -
    , - - . - , , record ,
    , . .
    "640K ught to be enough for anybody" - Bill Gates, 1981
    ::Machine specs::Fract::AGG::::Baileys::blog::YouTube channel

  16. #16
    Registered User
    Join Date: Aug:2006
    Location:
    Posts: 4,052
    Quote Originally Posted by DiadoMraz View Post
    XML .. -
    , ?

    XPath/XQuery / , xslt.

    , , .

  17. #17
    Registered User
    Join Date: Jul:2005
    Location: Sofiq
    Posts: 2,798
    Quote Originally Posted by DiadoMraz View Post
    ...
    . , - - .
    ...
    MySQL, DATEDIFF TIMEDIFF , 400 /, . , , int. : " 1 , 10 , 1 2 ..." / , : TIMEDIFF .

    Edit: DATEDIFF , TIMEDIFF e 838:59:59. , 2 , , () .

    int :
    2 : dt: DATETIME, dt_unix INT.
    Code:
    EXPLAIN SELECT * 
    FROM  `test_table` 
    FORCE INDEX ( dt_unix ) 
    WHERE UNIX_TIMESTAMP( ) -172800000 > dt_unix
    
    SIMPLE	test_table	range	dt_unix	dt_unix	4	NULL	1	Using where
    
    
    EXPLAIN SELECT * 
    FROM  `test_table` 
    FORCE INDEX ( dt ) 
    WHERE DATEDIFF( NOW( ) , dt ) >2000
    
    SIMPLE	test_table	ALL	NULL	NULL	NULL	NULL	2	Using where
    
    EXPLAIN SELECT * 
    FROM  `test_table` 
    FORCE INDEX ( dt ) 
    WHERE DATE_SUB( NOW( ) , INTERVAL 2000 DAY ) > dt
    
    SIMPLE	test_table	range	dt	dt	8	NULL	1	Using where
    2 , 2 000 000 200 000 . , e MySQL-a. " > ", (range). DATETIME , .
    Last edited by _ShadoW_; 17th October 2009 at 21:11.

  18. #18
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    Quote Originally Posted by _ShadoW_ View Post
    MySQL...
    - . Borland Paradox ...

    - MSSQL getdate() - 2000 2000 . , 2 .

    - 4 8 . , 1TB
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

  19. #19
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    .
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

  20. #20
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    XML-a ? XML . .
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

  21. #21
    Registered User
    Join Date: Aug:2006
    Location:
    Posts: 4,052
    exist-db
    / . , full-text indexing .

  22. #22
    Registered User
    Join Date: Oct:2006
    Location: Plovdiv
    Posts: 305
    ... full-text XML , ( ) XML . !

    - datetime full-text indexing XML :

    select invoice_date, sum(invoice_total)
    from invoices
    where invoice_date >= '2009-01-01' and invoice_date < '2009-06-01'
    group by invoice_date

    ?

    200,000 ( ) .
    Last edited by DiadoMraz; 17th October 2009 at 03:10.
    prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |