This expression is used when you meet/see someone you haven't seen in a long time, in the following ways.
'It is nice to see you' - This would be used at the start of the conversation when you meet each other
'It is nice seeing you' - This would be used during the conversation
'It was nice seeing you'/
'It was nice to see you' - These would be used at the end of the conversation as you say goodbye.