Converting a MySQL query

• Lucas Young

  Newbie

  Points: 9

  More actions

  January 5, 2005 at 9:29 pm

  #162105

  Hi Guys

  I'm new to SQL Server 2000 and am trying to convert some of my php code that previously used MySQL.

  Here's the query I'm having trouble with:

  SELECT *,UNIX_TIMESTAMP(lastlogin) as lastlogindate from user WHERE confirmed='1' and approved='1' and login = 'blah' AND password = PASSWORD('blah');

  SQL Server doesnt like the UNIX_TIMESTAMP conversion, or the PASSWORD data type. Is there a guide to converting this sort of query? How are unix timestamps and encrypted passwords handled in SQL Server?

  kind regards and thanks in advance

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 6, 2005 at 1:46 am

  #536124

  See, if this helps:

  http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]