7924 Posted January 22, 2008 Report Share Posted January 22, 2008 (edited) Kādā veidā šo jāraksta priekš mssql? priekš mysql man škiet ir šādi: SELECT * FROM tabula WHERE tabula.datums > '2007-05-1' bet kā tas būs iekš mssql, konkrēti vēlos uzzināt, kā mssql jāraksta "WHERE tabula.datums > '2007-05-1'" šis gabals? tabula kolonaa datums ir "datetime" ieraksti rādās šādi: 01.05.2007 0:00:00 tātad man vajag nosortēt datus, kur kolonā datums ir lielāks par 2007-05-01 Paldies! Edited January 22, 2008 by 7924 Link to comment Share on other sites More sharing options...
andrisp Posted January 22, 2008 Report Share Posted January 22, 2008 Tā arī raksti, tikai nevis 2007-05-1 bet 2007-05-01. Arī uz MySQL tas pats attiecas. Link to comment Share on other sites More sharing options...
Delfins Posted January 22, 2008 Report Share Posted January 22, 2008 (edited) "kā parasti" Strādās, gan `01`, gan `1` Otrkārt, kāpēc jautā forumā, ja jau sen varēji notestēt pats! Edited January 22, 2008 by Delfins Link to comment Share on other sites More sharing options...
7924 Posted January 22, 2008 Author Report Share Posted January 22, 2008 jā tiešām strādā, kaut kā, nein kā biju iedomājies ka formāts YYYY-MM-DD ir priekš mysql un pat neizmēģināju šo variantu! Paldies Link to comment Share on other sites More sharing options...
andrisp Posted January 22, 2008 Report Share Posted January 22, 2008 Strādās, gan `01`, gan `1` Delfins, strādās, bet vai pareizi ? Link to comment Share on other sites More sharing options...
Delfins Posted January 22, 2008 Report Share Posted January 22, 2008 mans domāt jā. vari pārbaudīt. Link to comment Share on other sites More sharing options...
andrisp Posted January 22, 2008 Report Share Posted January 22, 2008 Jā, tev taisnība. Link to comment Share on other sites More sharing options...
Recommended Posts